Problem in Query

[Care Career]

Hi I have 3 tables e.g A,B,C. I am joining table A and table B on the bases of id Select A.id,B.Name from A,B where A.id=B.id . Now i want get records from table C basis on calculated A.id. These all I want in One Query. Is tht Possible? Thanks Care Career

[Raviii_1983]

U can use the following code Select * from C where id in (Select A.id from A,B where A.id=B.id)

[Usharva]

Hi try this query Select A.id,B.Name,C.Calc From A,B,C Where A.id = B.id And A.id = C.Id Or Select A.Id, Name, Calc From A Inner Join B On B.Id = A.Id Inner Join C On C.Id = A.Id Hope this will work but there should be relation between these tables

[Care Career]

I want all the fields from 3 tables. This query solves fethes data from C table only i want data From a or b also SO can u help? thnx care career