InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

I understand that instant DB cannot do more than 1 join using "outer" or "inner" methods.
You can get around doing more than 1 inner join by performing it in the where clause.
Regards,
Rhys

-----Original Message-----
From:	Jonathan Lai Lam [SMTP:jlailam@hemtech.co.za]
Sent:	Friday, 16 February , 2001 7:35
To:	instantdb@enhydra.org
Subject:	InstantDB: Problem with OUTER JOINS 

Hi there, I am having some problems with this query.

I have got three tables A,B and C. Now I need to make a outer join
between table A + B and C + B

JobTypeSize  = A
JobEstimate  = B
NoOfColors  = C

  select *
    from JobTypeSize jts LEFT OUTER JOIN JobEstimate je ON
je.jobTypeId    = jts.jobTypeId   AND je.sizeId     = jts.sizeId,
               NoOfColors  noc LEFT OUTER JOIN JobEstimate je ON
je.noOfColorsId = noc.noOfColorsId AND je.jobTypeId = noc.jobTypeId
where jts.jobTypeId = 1
     and noc.jobTypeId = jts.jobTypeId;

Now the problem is that I don't know the right syntax, and the result is
that instantdb rightfully thinks there are two instances of table B
JobEstimate, where as I am only want there to be one instance.

Please is there a way to get this right?

Thank you kindly

Jon


-----------------------------------------------------------------------------
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.