Re: [Phpwebsite-developers] sql table joins

[Adam M. <ad...@tu...>]

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