Need query

[micydon]

Hi My requirement is i hve 4 tables Specmast(specification,wgt,min) specgen(specification,wgt,min) specem(specification,wgt,min,em) specdes(specification,wgt,min,desg). All the specification i hve stored in the first table. Now what i want is in specgen i hve to get those specification details from specmast which are not in specem and specdes. How can i give query for this Pls help me this is very important Thanks in advance Regards Micydon

[r a j u u]

Select * from Specmast where specification not in(select specification from specem,specdes) u will try this query....

Rajendran

[Senu Gandhi]

Micydon , Select specification,wgt,min from Specmast Where specification not in (Select e.specification from specem e Inner join specdes d on e.specification = d.specification ) This will work Senthil