How to join two single tables

[#1]

Hello

I have just two single tables i like to join. How is the syntax?

SQL SELECT

actno, nm, supno

FROM F1100.dbo.Actor;



SQL SELECT

R2, R10, VoNo, EntNo, Sup, AcNo, VoDt, AcPr, Qty, AcAm, Txt, Txt2

FROM F1100.dbo.AcTr;

I like to join supno and sup....

Please help

[#2]

You will need to rename the two fields to have the same name.  Then QV will join them automatically. 

[#3]

Hello Heather

I can not rename this fields in SQL database. This is in use from the main acounting system. Is it some way to rename in QV?

[#4]

Sorry, I should have been more clear.  Just give them an alias in the query, not rename in the database.

[Gysbert_Wassenaar]

Give the field Sup the alias supno. That way Qlikview can associate the two tables:

Table1:

SQL SELECT

actno, nm, supno

FROM F1100.dbo.Actor;

Table2:

SQL SELECT

R2, R10, VoNo, EntNo, Sup as supno,

AcNo, VoDt, AcPr, Qty, AcAm, Txt, Txt2

FROM F1100.dbo.AcTr;

[#6 · Accepted solution]

Thanks !! I give it a try tomorrow

[#7]

I have tested, and i works perfekt!!

Thanks to all