>-----Original Message-----
>The problem is I have a table called Products and a table
>called Order_Items. Customers can place many orders so
>what I want to do is for one particualar order show all
>Products but link to Order_Items on a left join so that
>for ordered. The problem is when I filter out for the
>Order I want, it only shows me items ordered and not all
>Products. I have tried to create the filtering in a
>separate stored procedure and left join this stored
>procedure with the products table but when I run this
>procedure using the Query analyser I get the message that
>it can't find the stored procedure which is used to do
the
>filtering.
>
>Does anyone know if you can call a stored procedure
within
>a stored procedure? Or is there another way of doing
>this? I am only new to SQL and come from an Access
>background where you can call up a query within another
>query.
>
>Any help much appreciated.
>
>Angela
>
>.