Hi Jason, I'd be really grateful if could help me with my SQL query. I have this:
SELECT * FROM items INNER JOIN contacts ON items.ItemSupplierID=contacts.ContactID INNER JOIN decor ON items.ItemDecorID=decor.DecorID INNER JOIN contacts ON decor.DecorSupplierID=contacts.ContactID
which returns the error message:
MySQL Error: 1066 Not unique table/alias: 'contacts'.
Sorry I know there must be a way around this, but I can't seem to find it. I'm not using DataBridge, still haven't migrated from the old DataAssist. If this isn't an easy solution I'll book in for a premium support ticket. Thanks.