We have a simple bunch of Access queries
(procedures/views) similar to the following but cannot get
them to work in SQL Server. We are missing something
obvious and would be very grateful to know what.
We have a database with three simple, obvious and
normalized tables called Products, Orders and Order_Lines.
We wish to produce a procedure with an output like:
Prod. Desc. OrderNo Qty
A AAAA 1000 2
B BBBB 1000 5
D DDDD 1000 1
E EEEE 1000 4
which is a list ALL products with the quantity (if any) of
each product ordered ...