Help - Converting a SQL Query into Access

[paularthur09]

Hi,

Can someone please help me convert the below SQL Server query into an Access friendly version?

select l1.*
from
tbl_sac_contract_1516_line l
join tbl_sac_contract_1516_line l1
on l.com_CODE = L1.COM_CODE
AND L1.TYPE = 'NCA'
where 
L.c_no = 'c15'

Any help will be really appreciated.

Paul

[orange]

Can you tell us more about your tables and the application this is intended to support?

[cyanidem]

It should run properly in Access in its current form, assuming there is table tbl_sac_contract_1516_line with relevant fields.

[paularthur09]

Thank you everyone but I have sorted it. I needed brackets around my join.

select l1.*
from
[Contract Line] l
INNER JOIN [Contract Line] L1
ON (L.Com_Code = L1.Com_Code AND L1.Type = 'NCA')
where 
L.c_no = 'c15'