Loading

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

P Narasimha

13y3.3k

Hi All,

Can you please help me on this.

I have tables t1,t2,t3

common column an in 3 tables id.

now i want select t1.colm1,t1.clom2,t2.clom1,t2.clom3,t3.clomn2 from t1,t2,t3 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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Blocked Account13y ago
Hi,

There is no query.
P Narasimha13y ago

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
Blocked Account13y ago
Hi

Can you explain your problem in more detail.

Thanks