5 Replies Latest reply: Sep 7, 2018 3:59 AM by Amir Mohamed RSS

    help needed with QS join

    Amir Mohamed

      Hi All,

       

      I need help with a thing.

       

      I have 3 tables

       

      Calendar   365 dates

       

      Stock    50 products

       

      Sales  30 products    and 40 dates

       

       

       

      Calendar is linked to sales based on sales_date and Sales is linked to Stock based on Product_code, they are linked based on same Alias (field names)

       

      My problem is

      I have products that are in Stock table that doesn't show their data as there are only 30 products with data on Sales as there's a link between them.

       

      Calendar:

      Load *, date as sales_date

       

      Stock:

      Load *, product as product_code

       

      Sales:

      Load *, code as product_code,

      invoice_date as sales_dat

       

       

      even though that Stock has more products data but because sales has less products field product_code only shows the products that both of tables has,

       

      But i want to show the 20 more products that does are not in Sales but exist in Stock

       

      Would you please be able to help?

       

      Many thanks,