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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
