|
Posted by knowzero on 03/21/07 19:22
my query:
select Product_List.*, Product_Sales.*
from Product_List
left outer join Product_Sales on Product_List.ID = Product_Sales.ID
this works fine. its simple. I have this in a report and I would like
to add a parameter @p1 to add to the query
where Product_Sales.Order_Amount >= @p1
my problem is that if @p1 is null I want to retrieve all recorders in
Product_List. any ideas.
Do you need more clarification.
Navigation:
[Reply to this message]
|