Join Problem

[#1]

I have two tables, one with Part Number Master data and one with sales history. I am using unquallify to link the table with the part number. I need to see "all" part numbers in the master table, not just ones that match the sales table. I have tried various joins but I must be doing something wrong. Help!

Thanks,
Stephen

[#2]

Hi,

I`m not sure, I understand your query.

Part_No_Master:

Load Part_No,

Part_Desc,

Part_Reg

From Part_Number ;

Left Join

Load Part_No,

Sales,

Sales_Rep

From Sales;

Above should help you get all the Part numbers from Part Master.

Hope so this would help you, if this doesnt solve your purpose.

Plz post sample of your data with explanantion.

- Sridhar

[#3]

Hi,

or better (I think) leave out the "left join" and let Qlikview do the linking of the two tables. Make sure the names of the PartNumber is the same in the tables.

So just load the two tables and you can have all the items from the master table in e.g. a list box.

regards,
Walter.