Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day gyus How do I inner join 2 table on a specific field. I have the following data. How would the script look like if I want to join them on DocEntry??
SQL SELECT CardCode,DocDate,DocEntry,DocNum,DocType FROM "SBO_O_SA1".dbo.OPDN;
SQL SELECT DocEntry,LineTotal,Quantity,ItemCode FROM "SBO_O_SA1".dbo.PDN1;
Hi Christo.
Tab1: // Name the table, so you can join it
SQL SELECT CardCode,DocDate,DocEntry,DocNum,DocType FROM "SBO_O_SA1".dbo.OPDN;
INNER JOIN (Tab1) // Join Tab1
Load DocEntry,LineTotal,Quantity,ItemCode; // Preceeding load, you join via DocEntry.
SQL SELECT DocEntry,LineTotal,Quantity,ItemCode FROM "SBO_O_SA1".dbo.PDN1;
Kind regards, Miha
Hi Christo.
Tab1: // Name the table, so you can join it
SQL SELECT CardCode,DocDate,DocEntry,DocNum,DocType FROM "SBO_O_SA1".dbo.OPDN;
INNER JOIN (Tab1) // Join Tab1
Load DocEntry,LineTotal,Quantity,ItemCode; // Preceeding load, you join via DocEntry.
SQL SELECT DocEntry,LineTotal,Quantity,ItemCode FROM "SBO_O_SA1".dbo.PDN1;
Kind regards, Miha
Hello Christo,
I may have misunderstood your question but, since QlikView joins tables (links them) when both share a field with same name, I don't think forcing a join would be necessary in this case. It'a just enough to keep fields with the same name
Hope that helps.
Thank you both for the help.
I know that Qlikview joins automatically. But I needed to INNER JOIN in some instances.
This was only a simple example.
Regards
Hi ,
i have a question
what if i want to join only specific row that is not there in the another table
For example ,
Table A had fields like Emp , id, name ,role
Table B had : date,place.
now my final table should look like : Emp,id,name,role,place.
How it was possible ?