>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?