Thank you for reply Leonardo. I'm using SqLite. I tested the query with sqlite command line tool. The query is correct. The problem is Zeos.
2010/1/12 Leonardo M. <l.r...@griensu.com> > 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 >
-- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus