I'm testing a query out in Access2K that has all it's tables connected to postgresql 7.4. Once my test queries run fine I put them in my php code. I'm testing the following query out but Access complains that there is an ambiguous outer join. It's only when I include the tbl71 connected to tbl63 that it complains. If I create a seperate query for tbl63 and tbl71 and then use that query in the sql statement it works fine. So I'm thinking there must be a way around this to get it working without the 2 seperate queries. Can anyone shed some light on this one?


SELECT
tbl95view1.col27,
tbl95view1.col3,
tbl95view1.col28,
tbl95view1.col35,
tbl88view2.col1,
tbl45.col5,
tbl47.col2,
tbl47.col3,
tbl47.col17,
tbl45.col4,
tbl91view1.col19,
tbl63.col3,
tbl53.col2,
tbl91view1.col21,
tbl91view1.col22,
tbl91view1.col21*tbl91view1.col22 AS totalpay

FROM
(((((tbl95view1 INNER JOIN tbl88view2 ON tbl95view1.col35 = tbl88view2.col20)
INNER JOIN tbl91view1 ON tbl88view2.col1 = tbl91view1.col13)
INNER JOIN (tbl45 INNER JOIN tbl47 ON tbl45.col2 = tbl47.col1) ON tbl88view2.col13 = tbl45.col1)
LEFT JOIN tbl53 ON tbl91view1.col23 = tbl53.col1)
LEFT JOIN tbl63 ON tbl91view1.col27 = tbl63.col1)
INNER JOIN tbl71 ON tbl63.col4 = tbl71.col1

ORDER BY tbl95view1.col35 asc;