Hey, thanks for looking at it. I'm sure those are exactly spot on. However, what I cannot figure out is why the very end of the statement is throwing the error where the ON portion is. Both tables have that field and the field is identical. When I miss something, it is usually something very obvious, so I thought if I posted it, I may actually see it. However, not tonight obviously!






>Those spaces in the right arguments make me nervous. Are you sure they're all the right length?
>
>
>>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?