i have three tables: products,orders and orderlines and I want to make
a procedure which will give the quantity of each product ordered under
a given order number ( I still want the product to show even if there
is no quantity). I need to first eliminate all the inappropriate rows
from the orderlines table with a filter.
I have created a UDF which I think will create a table with the
filtered records(below). I then use my sproc and run the UDF with a
left join to the temp table.
I am trying to test this from a website ...