topic Re: SQL JOIN STATEMENT in QlikView

SQL JOIN STATEMENT

Fri, 20 Nov 2020 18:02:30 GMT

suppose i have 2 table emp and det

select A.ID,A.DOB,B.PLACE,B.AGE

FROM EMP A JOIN DET B

ON A.ID=B.ID INTO DET

is the above sql statement is possible in QV, I want to load the 2 joined table in the new table

Note in the above SQL statement joined results has been loaded to DET table

Kindly suggest

Thanking You

Vinayagam

Re: SQL JOIN STATEMENT

Gysbert_Wassenaar — Wed, 26 Mar 2014 12:12:56 GMT

You can just use the sql statement as is in Qlikview so you get the already joined results from the database. If you want to do the joining in Qlikview you need two load statements like:

DET:

Select A.ID as ID, A.DOB

From EMP;

join(DET)

Select B.ID as ID, B.PLACE, B.AGE

From EMP;

If you get all the data from the same database I would do the joining in the sql statement so the database does the work. If you get the data from two separate database then you need to load statements like above. Of course you'd need another Connect statement too to connect to the second database after the first load.

Re: SQL JOIN STATEMENT

Wed, 26 Mar 2014 12:14:50 GMT

YUP SIR THANKS

BUT I WANT TO LOAD THE RESULT OF JOIN INTO ANOTHER TABLE IS IT POSSIBLE..???

Re: SQL JOIN STATEMENT

Gysbert_Wassenaar — Wed, 26 Mar 2014 12:17:04 GMT

You already have that. I gave the table the name DET.

DET: //<- that's the name given to the new table

select ....

Re: SQL JOIN STATEMENT

its_anandrjs — Wed, 26 Mar 2014 12:25:43 GMT

Yes it is possible

DET:

Select ID,PLACE,AGE

FROM DET

Join

Select ID,DOB

FROM EMP

Hope this helps

Thanks & Regards

Re: SQL JOIN STATEMENT

maxgro — Wed, 26 Mar 2014 12:38:29 GMT

or you can also use the same sql statement (join in dbms)

DET:

select A.ID,A.DOB,B.PLACE,B.AGE

FROM EMP A JOIN DET B

ON A.ID=B.ID;