Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
New Contributor III

SQL Select with Join

Hello,

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

Clipboard02.jpg

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 ?

1 Solution

Accepted Solutions
Highlighted
Esteemed Contributor

Re: SQL Select with Join

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

View solution in original post

1 Reply
Highlighted
Esteemed Contributor

Re: SQL Select with Join

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

View solution in original post