I'm stuck again. After the variables are evaluated, I get the code below. Just one of those days again. I test the code below and the error is a problem with the syntax near 'ON' - 'Incorrect6 syntax near the keyword 'ON'. ODBC Err#156
SELECT * FROM table1 AS tw INNER JOIN
(SELECT table2.inci_id FROM table2 AS Tbl1
WHERE table2.inci_id = '07000244 '
or table2.inci_Id = '2007093878 '
or table2.parent_id = '07000244 '
or (LEN(table2.parent_id)>0 AND table2.parent_id = '2007093878 '))
ON tw.inci_id = Tbl1.inci_id ORDER BY tw.inci_id, tw.vehnum
I can't see it, can you?
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"