a query is working at first,,then when i add an aliase to a table, it
doesnt work..this is using the SQL view for querying in MS Access 2002
(XP)........
for example
SELECT invoice_id, companies.name AS billing_company, total, date
FROM invoices INNER JOIN companies
ON invoices.billingcompany_id=companies.company_id
is working..but the following is not
SELECT invoice_id, companies.name AS billing_company, total, date
FROM invoices INNER JOIN companies AS C1
ON invoices.billingcompany_id=C1.company_id
access is giving me this error: Syntax error in JOIN operation. I am
new to SQL and even newer to Access.. can someone help?