[Lazarus] Zeos Component Join Query

David W Noon david.w.noon at ntlworld.com
Tue Jan 12 20:00:25 CET 2010


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]
=======================================================================
david.w.noon at ntlworld.com (David W Noon)
=======================================================================




More information about the Lazarus mailing list