SQL Select with Join

Chernov — Mon, 08 Jul 2013 01:02:49 GMT

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 ?

Re: SQL Select with Join

vikasmahajan — Mon, 08 Jul 2013 05:56:21 GMT

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