Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Associated TSQL Query

Author  Topic 

vijay1234
Starting Member

48 Posts

Posted - 2014-09-18 : 02:20:27
Hi friends,

Here's one more requirement.

I have 4 tables A,B,C,D

A--->B---->c---->D

All are having ID columns with PK on A & FK's on B,C,D

If i give D.id = 30 then the result should come for A table. No matter whether the same is existing in B,C tables.

Hope i'm clear.

So just to know how to approach this scenario.

Thanks,
Vijay

Arun Babu N
Starting Member

26 Posts

Posted - 2014-09-18 : 04:50:51
you can use 'Join'

arunbabu
Go to Top of Page
   

- Advertisement -