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 |
|
cobby1812
Starting Member
16 Posts |
 Posted - 2012-06-11 : 06:04:27
|
| Hi there,I have a Table called NO2. In there I have a field called DateDate is a nchar(6) and looks thus 12160 - in simple terms it is broken down as 12 (being the year) and 160 (being the days from 1st Jan till today)I created another table called Dates, in there I have nchar(6) field to match the files one and a smalldatetime field showing the date in 103 format.When I try and link the tow together nothing returns.i.e SELECT * FROM NO2LEFT OUTER JOIN DATESON NO2.DATE = DATES.DATESTRINGI have tried Inner and Outer etc. What am I doing wrong. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-06-11 : 06:34:16
|
Don't know.Have a look at the data, maybe in one table the column has leading space and the other one has trailing space?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Incorrect Joining Maybe???