Question on Data modeling

[nikhilgandhi715]

Hi All,

I have total 20 products in my products table; however in the order table i have data for 15 products only. In my listbox I want to display all these products even if there are no orders to it.

I tried inserting a different table for all the products, but it is not working.

Any help would be much appreciated.

Thanks and regards,

Nikhil Gandhi.

[#2]

Dear Nikhil,

Just outer join both tables Products and Orders and all the products will be in Product Field whether It is sold or not.

Thanks & Regards

Prince Anand

[vinay_hg]

use product table products column in the filter that will work

[nikhilgandhi715]

Hi Anand,

Could you please let me know what Syntax do I need to use, as I am not joining the tables in Oracle?

[nikhilgandhi715]

Hi Vinay,

I tried doing it, but it takes only those products where I have data in the Fact table while I need to display all the products.

[#6 · Accepted solution]

Dear Nikhil,

Load Both Tables Product and Orders and outre join them like:-

load productname,

productid from products;

join

load orderid,

productid from orders;

then after reload you have one field with productid and productname and one with orderid and then use that productname as filter .

you have all the products in that field.

Thanks & Regards

Prince Anand

[nikhilgandhi715]

Hi Anand,

It worked just what I was looking for. Thank you very much for the help, really appreciate.