select top 1 column data from the 3 tables using joins or any other

Question

Hi All Can you please help me on this. I have tables t1t2t3 common column an in 3 tables id. now i want select t1.colm1t1.clom2t2.clom1t2.clom3t3.clomn2 from t1t2t3 and selcet top1 t1.clomn1 from t1 table and get data from 3 table using joins or any other like where condition using id column is the common for 3 tables. please help me on this. Advanced Thank you. Regards Narasimha

Manish Dwivedi · Answer

Hi There is no query.

P Narasimha · Answer

Hi Manish thank you for quick response The problem is below query please look into this and let me know. Please find here is the txt file query. from that query i need product select top1 and all records from item table without duplicates. Thanks Narasimha

Manish Dwivedi · Answer

Hi Can you explain your problem in more detail. Thanks