On Jan 2, 2004, at 8:55 PM, Andy Lewis wrote:
> Yes, I understand this but, I would like to have the results of both
> "table1.name, table2.name"
> sorted as one column.
>
> Is this possible?
So you want one column of name, including names from both table1 and
table2? In that case, you need to use UNION, I believe. If it's
something else, I'm not sure I understand what you're asking. Perhaps
you could include a sample of what you're getting, along with what
you'd like to see?
Michael Glaesemann
grzm myrealbox com