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 - 2000-12-08 : 20:22:41
|
Donna writes "Dear SQL Guru,
I have two tables that are used by two different departments. In Table A, the Unique Value is a 12 digit number that always starts with 2000. In Table B, the unique Value is a 10 digit number that always starts with 00. Other than this small inconsistency these numbers are the same and are the link to join these 2 tables.
My question is how do I (or can I) use the RIGHT command to join the tables? In other words I want to make the following query work (select * from Table A Left Join Table B ON TableA. Right (valueA, 10) = TableB.valueB ) but it doesn't. If the Right command cannot be used in a join portion of the statement, what are my other alternatives? I am using SQL 6.5 with server pack 4." |
|
|
|
|
|
Joining tables with similar values in SQL