Re: [Phpwebsite-developers] sql table joins

[Don S. <do...@se...>]

AFAIK, Oracle does not support the join syntax as listed there.  oracle's 
left outer join syntax would be something like:

select * from tableA, tableB
where tableA.id = tableB.id(+)

The (+) is where it knows which is the lesser table for the outer join.

Don.

On Tue, 4 Feb 2003, Adam Morton wrote:

> Matt, checking out mysql.com I found the JOIN syntax page and most of the
> syntax here is standard sql with no special mysql bells or whistles (with
> a couple of exceptions).  It should work on multiple DBMS's.  Hope it
> helps:
> 
> http://www.mysql.com/doc/en/JOIN.html
> 
> Adam
> 
> > I guess it could be tricky, since join syntax is not standard across all
> >  DBMS's, unless pear handles some kind of "join abstraction".
> >
> > I guess I can just get the separate results and loop to my heart's
> > content.
> >
> > Don.
> >
> > On Tue, 4 Feb 2003, Matthew McNaney wrote:
> >
> >> > Is there a mechanism in place to support table joins?  sqlSelect
> >> would work as long as you don't have a table prefix in place but
> >> that is more of  a kludge than anything.
> >> >
> >> > Don.
> >>
> >> I'm not sure. I haven't used joins since Access and I am not familiar
> >> with them in SQL.
> >>
> >>
> >>
> >
> >
> > -------------------------------------------------------
> > This SF.NET email is sponsored by:
> > SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> > http://www.vasoftware.com
> > _______________________________________________
> > Phpwebsite-developers mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 
> 
> ---------------------------------------------------------------------
> Adam Morton
> Developer - Electronic Student Services
> http://phpwebsite.appstate.edu
> Founder - Appalachian Linux Users Group
> http://alug.appstate.edu
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.NET email is sponsored by:
> SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> http://www.vasoftware.com
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 
> 
>