Hi,

I have two tables:

  - Customers
  - Invoices

I got an *sql logic error* trying to execute following query using Zeos
Component (ZQuery):

"SELECT Invoices.*, Customers.Name
 FROM Invoices
 LEFT JOIN Customers
 ON Invoices.CustomerID= Customers.ID
* WHERE Customers.Name = 'Tom' "*

excluding the Where clause make the query run without problems.

Thank you
Max
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Reply via email to