Got it working! :o) *GGGGGGGG* with the following two changes:

SELECT * from table3 as vh
INNER JOIN (SELECT tw.* from table1 as tw...

which is almost identical and makes no sense to me, but it returns the correct results. Yahoo! Thanks, thanks, thanks!



>>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.
>
>Sorry, my mistake, you must use ALIAS in field list and WHEREs not actual table names
>

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

>
>
>If you want all fields form table2 try this:
>

>SELECT * from table3 as vh
> inner join  (SELECT tw.veh_id, qry1.* FROM table1 tw
>                     INNER JOIN (SELECT table2.* 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
>