MySQL 5: Inner join problem
Posted on 2007-09-30
Need some help explaining how I should build my inner join sql qery
I already have a query, strSqlQuery, but I don't understand why it looks like it does.
(I have no createed this query from the beginning)
why is this question buld in this way, why are there DATE before the WHERE statment and not after and so on.
This is what i want to do:
1: I get all records from T1 that has the FileDate = yyyyMMdd
2: I need to comapre all these records with T2 table.
3: Uniqe key is DATE, T_NR, and K_NR in both tables
4: I only need the records that the VAULE is not the same
strSqlQuery = "SELECT " & _
"T1.DATE, T1.TIME, T1.VALUE, " & _
"T"2.VALUE" & _
"FROM T2 INNER JOIN T1 ON " & _
"(T1.FileDate '" & fileDate & "') AND " & _
"(T1.DATE = T2 .DATE) AND " & _
"(T1.T_NR = T2 .T_NR) WHERE " & _
"(T1.K_NR = T2 .K_NR) AND " & _