Hi, here is the problem...
I must create a store procedure that do the following...
1. select id_name,...'some other field' from table 'data' where 'criteria' =
@parameter
2. use the result of the first selection to create another selection
combining that results with the table 'name' where id_name is null in the
result selection...
In other word I have a first query that use a passed parameter, the result
of that query should be combined this another query, and the result should
be return from the store procedure...
I can't realize how to write this 'simple' problem... can anyone help me?
Many thanks,
Alex