> can i have a result set. just like the outer join returns.
> but on my case. return null on duplicates.
> like this one.
>
> survey :category :question :answer
> -----------------------------------
> survey1:category1:question1:answer1
> : : :answer2
hmmm.. I am no sure that you are going to get what you want from a simple select query.
A reporting software could do this easily however.
also be sure to include the list in your replies :-).
Regards,
Richard Broersma Jr.