On Tue, 12 Jan 2010 19:01:48 +0100, Massimo Fazzolari wrote about Re: [Lazarus] Zeos Component Join Query:
> The problem remain. Now i can't apply any filter to Invoices > fields! :( > > For example this query raise an exception: > > "SELECT Invoices.*, Customers.Name > FROM Customers > RIGHT JOIN Invoices > ON Invoices.CustomerID= Customers.ID > * WHERE Invoices.Number > 3"* The join should be an INNER JOIN if you want constraints on columns of both tables.. What has any of this to do with Lazarus? -- Regards, Dave [RLU #314465] ======================================================================= [email protected] (David W Noon) ======================================================================= -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
