Scott
You can do 4 way joins in the WHERE clause, but not in the FROM clause.
What this effectively means is that you can't do an OUTER join on more
than two tables.
There are no immediate plans to change this right now.
Regards
Pete
----- Original Message -----
From: Scott Plante <splante@insightsys.com>
Date: Thursday, January 25, 2001 9:56 pm
Subject: InstantDB: more than two table joins
> We need to do a four table join. It appears from the documentation
> that only two tables are allowed in the join at this time. Is
> there a
> good work-around for this? Is this on the near-term enhancement
> list?
>
> Scott
>
> -------------------------------------------------------------------
> ----------
> To unsubscribe from this mailing list, send email to
> majordomo@enhydra.orgwith the text "unsubscribe instantdb" in the
> body of the email.
> If you have other questions regarding this mailing list, send
> email to
> the list admin at owner-instantdb@enhydra.org.
>
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|