Posted - 06/11/2012 : 06:04:27
| Hi there,
I have a Table called NO2. In there I have a field called Date
Date 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.
SELECT * FROM NO2
LEFT OUTER JOIN DATES
ON NO2.DATE = DATES.DATESTRING
I have tried Inner and Outer etc. What am I doing wrong.