Access query error 1

[BasicBoy]

Can someone please tell me where the error is in this query.

SELECT
incomeforecast.id,
mydate,
incomevotes.votename as incomevotename,
origin,
incomeforecast.refno,
amount,
bankvotes.votename as bankvotename
FROM
incomeforecast
LEFT JOIN
(votes as incomevotes on incomeforecast.voteno=incomevotes.voteno)
left join votes as bankvotes on incomeforecast.bankvoteno=bankvotes.voteno
WHERE
bankvotes.bankvotename='Pro Housing Bank - 405 119 0248' order by 1 desc

Thank you

 

[PHV]

mydate, origin and amount should be prefixed with their table name.
Furthermore the WHERE clause defeats the purpose of the LEFT JPIN.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BasicBoy]

Thank you very much

Can you please look at this improved one.

SELECT incomeforecast.id, incomeforecast.mydate, incomevotes.votename as incomevotename, incomeforecast.origin, incomeforecast.refno, incomeforecast.amount, bankvotes.votename as bankvotename from incomeforecast left join (votes as incomevotes on incomeforecast.voteno=incomevotes.voteno) left join votes as bankvotes on incomeforecast.bankvoteno=bankvotes.voteno where incomeforecast.bankvoteno=501 order by 1 desc

I have an incomeforecast table with two fields - voteno and bankvoteno which should both be joined from the votes table (to get the names of these votes) and I only want to filter items which have a specific votenumber in the bankvoteno field in the incomeforecast table.

 

[PHV]

The left paren should be here:
from incomeforecast [highlight]([/highlight]left join votes

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

Oops, sorry for the typo.
The left paren should be here:
from (incomeforecast left join votes

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886