How to join 3 tables or more. Translating SQL View.

Fri, 09 Sep 2011 10:56:19 GMT

Hi, I'm trying to translate a view I have in a SQL server database to the script of Qlikview but I'm having problems:

ItemLedgerEntry:
LOAD*;
SELECT *
FROM    "$(_DBName)"."$(_DBOwner)"."$(_CompanyName)$Item Ledger Entry";
TariffNumber:
LOAD *;
SQL SELECT *
FROM    "$(_DBName)"."$(_DBOwner)"."$(_CompanyName)$Tariff Number";
Item:
LOAD *;
SQL SELECT *
FROM    "$(_DBName)"."$(_DBOwner)"."$(_CompanyName)$Item";

How do i join the 3 tables at the same time? The common fields are like following:

(LEFT JOIN)ItemLedgerEntry.ItemNo=Item.ItemNo and ( LEFT JOIN) Item.TariffNo=TariffNumber.TariffNo

I tried this but It doesn't work

Intrastat:
Load
"Posting Date",
"Document No",
"Entry Type",
"Item No",
"Country_Region Code"
Resident ItemLedgerEntry;
Left Join (ItemLedgerEntry)
IntervalMatch ( "ItemNo")
Load 
ItemNo,
Variety,
Specie,
TariffNo,
"Country_Region of Origin Code"
Resident Item;
Left Join (Item)
IntervalMatch ( "TariffNo")
Load 
TariffNo,
Description
Resident Tariff;

What am I doing wrong? Thanks in advance

topic How to join 3 tables or more. Translating SQL View. in QlikView

How to join 3 tables or more. Translating SQL View.