>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 tw.* FROM table1 tw INNER JOIN
> (SELECT table2.inci_id FROM table2 
> 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    ')) tbl1
> ON tw.inci_id = Tbl1.inci_id ORDER BY tw.inci_id, tw.vehnum
>

>I can't see it, can you?

See changes inline.