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