HP3000-L Archives

August 2003, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: minisoft and outer join's
From:
ssn232 <[log in to unmask]>
Reply To:
ssn232 <[log in to unmask]>
Date:
Wed, 13 Aug 2003 07:17:25 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (17 lines) 
 > I don't have minisoft odbc32 driver so can't check this recommendation
out,
> but I think you need another set of brackets round the second LEFT OUTER
> JOIN as in:
>
> > FROM {oj
> >    ((table1 LEFT OUTER JOIN  table2 ON
> >    table1.consignment = table2.consignment)
> >    LEFT OUTER JOIN table2 ON table1.transport = table2.transport)
> >    LEFT OUTER JOIN table3 ON table1.transport = table3.transport
> >    }
>
exacly thx :)

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2