Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-27 : 10:19:35
|
John writes "I found your article entitled "UNION: Selecting from multiple tables in one statement" to be very helpful, but I've got a more complex task that I can't seem to figure out.
Like your UNION example, I have two tables (Contact and Product) that share a common field (ConfirmationNumber). What I am trying to do is sort the return so that it only lists the entries where the ConfirmationNumber from both tables match, then sort it alphabetically ASC by an additional field within the Contact table called LastName.
Thanks for any help you can give,
John" |
|
|
|
|
|
validating from multiple tables while sorting from only one