I am beating my head against a wall on this one.
The query below generates this error
"Syntax error (missing operator) in query expression '(Ebay_posting.id=cint(order_items.ebaynumber)) inner JOIN inventory ON (Ebay_posting.description=inventory.ID'."
I and a bit new to using joins but I cannot see the issue here.
Code:
SELECT order_items.itemID, order_items.order_id,
order_items.ebaynumber,
order_items.qty,
order_items.shipping_charged,
order_items.shipping_cost,
order_items.defaultedby,
order_items.defaulteddate,
order_items.org_customer,
order_items.mac,
order_items.itemtotal,
nz(order_items.itemtotal,0)+nz(order_items.shipping_charged) AS gross,
(nz(order_items.itemtotal,0)+nz(order_items.shipping_charged))-order_items.shipping_cost AS net,
Ebay_posting.price,
Ebay_posting.lots_of,
inventory.Inventoryid
FROM Ebay_posting inner JOIN order_items ON (Ebay_posting.id=cint(order_items.ebaynumber))
inner JOIN inventory ON (Ebay_posting.description=inventory.ID);
I built this in steps and it worked until I added the parts in red.
Any Ideas?