Discussion Board for collaboration related to Qlik Education.
I am completely new to this QlikView world, but is on my way... :-)
I have many questions, but will take them one at the time...
Is there anyone, who help/guide me whit this query?
SQL select * from receiptline l, receipt r where r.created < "2015-01-01 00:00:00" and r.created > "2014-01-01 00:00:00" and l.receipt=r.id;
Is this the right way to write it in QlikView?
Go to Solution.
In your query you are selecting all the fields * from more than one table, in this case tables must be linked in some way, you should write:
SQL select * from receiptline l left join receipt r on l.receipt=r.id where r.created < "2015-01-01 00:00:00" and r.created > "2014-01-01 00:00:00";
hope this helps
Thanks, it worked perfectly...
maybe it works if the sql result set doesn't have duplicate field names
usually if a select statement works on your dbms it also works in QlikView as the SQL statement is sent to the dbms for the execution
some help here