In the final result set, I need all fields from table3, I also need all fields from table 2 eventually, but to pick out the appropriate matching records from table3 I only need the vehi_id field in the result set that creates qry2.

However, with your code changes, I still receive the error: "The column 'inci_id' was specified multiple times for 'qry2' which baffles me because the qry2 result qry is identical as when it id run alone. The only thing I am doing is putting it inside of the () inner join statement in the final query.

>You need ALL fields from both queries or you need only fields from Table3?
>
>
>
>

>SELECT table3.* from table3 as vh
> inner join  (SELECT table1.veh_id FROM table1 AS 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    ')) qry1
>                     ON tw.inci_id = qry1.inci_id WHERE canccode='    ') qry2
>on vh.vehi_id = qry2.veh_id
>