Thread: [Phpwebsite-developers] sql table joins

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

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.

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

-- 
Matthew McNaney
Internet Systems Architect
Electronic Student Services
Appalachian State University
Phone: 828-262-6493
phpwebsite.appstate.edu
ess.appstate.edu

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

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

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

Ah thanks :) I will learn.

Matt

-- 
Matthew McNaney
Internet Systems Architect
Electronic Student Services
Appalachian State University
Phone: 828-262-6493
phpwebsite.appstate.edu
ess.appstate.edu

> 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

On Mon, 2003-02-03 at 13:30, Don Seiler 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,
The only two Pear references I found for 'join' are below. I hope they
help.

    Version: 0.18-devel (2002-09-08) -- join()
    http://pear.php.net/package-changelog.php?pacid=85

    DB_QueryTool -- setJoin
    http://pear.php.net/weeklynews.php/en/20030119.html

-- 
Mike Noyes <mhnoyes @ users.sourceforge.net>
http://sourceforge.net/users/mhnoyes/
http://leaf-project.org/  http://sitedocs.sf.net/  http://ffl.sf.net/