Posted by Ed Murphy on 03/21/07 22:56

knowzero wrote:

> 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.

where @p1 is null or Product_Sales.Order_Amount >= @p1

[Back to original message]