inner joins via SQL

[excession]

Hi all,

I'm getting a wierd error when I try and run a query that uses a couple of inner joins, the SQL statement works fine when connected to a mySQL server, but throws a ' Reserved error (|); there is no message for this error.' with access.

The SQL query is:

select
l.job_parts_id,
l.part_id,
l.oil_id,
l.quantity,
l.purchase_price,
l.sale_price,

p.part_no,
p.description,
p.supplier_id,
o.part_no,
o.description,
o.supplier_id

from job_parts l

left outer join parts p
on l.part_id = p.part_id

left outer join oil o
on l.oil_id = o.oil_id

where l.task_id = 1
order by l.job_parts_id

Any ideas?

Thanks in advance.







Looking for a job as a programmer in Bristol UK.

 

[lupins46]

from (job_parts l

left outer join parts p
on l.part_id = p.part_id )

left outer join oil o
on l.oil_id = o.oil_id

 

[lupins46]

I'm not clear why your Subject refers to Inner Joins.

 

[excession]

thanks.

the subject refers to inner joins cause i haven't had enough coffee yet

Looking for a job as a programmer in Bristol UK.