lol - I have been developing in SQL for 4 or 5 years now, and I must admit
that I have never seen that done (the criteria in the JOIN clause) :-)



At 12:29 AM 06/27/2003 +1000, you wrote:

>At 04:07 PM 26/06/2003 +0200, you wrote:
> >The criteria should be in the WHERE clause and the joins in the JOIN clause?
>
>
>...and God's in His heaven. :-))
>
>H.
>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.491 / Virus Database: 290 - Release Date: 06/18/2003

[Non-text portions of this message have been removed]