Display ALL records (1 Viewer)

[jadeIT]

I want to display all the products in a products table, and then display the sum of the quantity of these items that are on the order table.

However, if a product thats in the product table is on no orders (that is there are no related records in the orders table), it will not appear in the query result at all.

I need records like this to sill appear in the result with the som of the quantity as zero. How can I do this.

 

[rich.barry]

You probably need to go into the join properties that link your 2 tables and change to 'Include ALL Records from Products and only those records from Orders where the joined fields are equal'

 

[jadeIT]

ok that sounds good.. could you give me an example of actual SQL code one would use ? that would be great thanks.

 

[rich.barry]

Try this

 

[jadeIT]

Thanks a lot, that's exactly what I need.