Massimo, please before trying with Lazarus/Zeos, please test your query using an external database administration tool like FlameRobin or IbExpert of you are using Firebird.
99% of the time, the problem isn't Zeos, but the query itself. -- Leonardo M. Ramé Griensu S.A. - Medical IT Córdoba Tel.: 0351-4247979 El mar, 12-01-2010 a las 18:07 +0100, Massimo Fazzolari escribió: > 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 > Lazarus@lists.lazarus.freepascal.org > http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus -- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus