SQL JOIN STATEMENT

[#1]

hi

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

[Gysbert_Wassenaar]

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.

[#3]

YUP SIR THANKS

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

[Gysbert_Wassenaar]

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

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

select ....

[its_anandrjs]

Yes it is possible

DET:

Select ID,PLACE,AGE

FROM DET

Join

Select ID,DOB

FROM EMP

Hope this helps

Thanks & Regards

[maxgro]

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;