SQL Select with Join

[Chernov]

Hello,

i have 3 tables in sql base: chequehead, chequepos and chequedisc

where:

chequepos.chequeid = chequehead.id

chequedisc.posid = chequepos.id

in QV - how i can select data from this tables with one condition on one table - chequehead.dateoperation ?

[vikasmahajan · Accepted solution]

Please try following

select * from [SES].[dbo].[ChequeHead] a

left join [SES].[dbo].[ChequePos]  b on  a.id = b.chequeid

left join [SES].[dbo].[ChequeDis]   c on  b.id = c.rowid

Please note in your query b.column name & c.column name as per requirement you can take. Also sure count the # of records

Vikas