Discussion board where members can get started with QlikView.
i have 3 tables in sql base: chequehead, chequepos and chequedisc
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 ?
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
View solution in original post