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 |
|
srussell
Starting Member
9 Posts |
 Posted - 2008-08-21 : 09:54:03
|
| I have 2 tables that store a list of address for specific members. I need to compare the list of addresses for a member depending on the order number selected by a user that is only stored in one of the tables. I have another number that both tables have that I can look up. So basically I need a query that will compare address fields where table.num = table2.num and table.otherNum = 'userselected'I am really struggling with this. If this doesnt make sense I can post more info. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-21 : 09:56:59
|
| may be this:-SELECT *FROM tableINNER JOIN table2ON table.num = table2.num WHERE table.otherNum = 'userselected' |
 |
|
|
|
|
|
Compare Addressess From 2 Tables