4 Replies - 2064 Views - Last Post: 20 March 2005 - 02:17 PM Rate Topic: -----

#1 SpaceMan  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 10
  • View blog
  • Posts: 507
  • Joined: 20-February 03

Join

Posted 20 March 2005 - 12:23 PM

been trying to get a bit of info on this, none at php.net.


what left outer join do in a query?
Is This A Good Question/Topic? 0
  • +

Replies To: Join

#2 skyhawk133  Icon User is offline

  • Head DIC Head
  • member icon

Reputation: 1877
  • View blog
  • Posts: 20,284
  • Joined: 17-March 01

Re: Join

Posted 20 March 2005 - 12:31 PM

This is more of a database question than a PHP question. *moved*

Check out this link from AnswerBag.com
Was This Post Helpful? 0
  • +
  • -

#3 SpaceMan  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 10
  • View blog
  • Posts: 507
  • Joined: 20-February 03

Re: Join

Posted 20 March 2005 - 12:46 PM

skyhawk133, on Mar 20 2005, 12:31 PM, said:

This is more of a database question than a PHP question. *moved*

Check out this link from AnswerBag.com

hmm, gues so, i useing php to do it, had not thot about that.
Was This Post Helpful? 0
  • +
  • -

#4 skyhawk133  Icon User is offline

  • Head DIC Head
  • member icon

Reputation: 1877
  • View blog
  • Posts: 20,284
  • Joined: 17-March 01

Re: Join

Posted 20 March 2005 - 01:10 PM

Even if you're using PHP to do it, mySQL and PHP are completely unrelated other than there is native support in PHP to connect and interact with a mySQL database. JOINS however are a database specific function available in Oracle, MSSQL, mySQL, and a number of other similar databases.
Was This Post Helpful? 0
  • +
  • -

#5 Amadeus  Icon User is offline

  • g+ + -o drink whiskey.cpp
  • member icon

Reputation: 248
  • View blog
  • Posts: 13,507
  • Joined: 12-July 02

Re: Join

Posted 20 March 2005 - 02:17 PM

I know that skyhawk has already answered the question fully, but just wanted to provide this link. It has some good examples of the major SQL statements and their uses...the JOINs and the other statements that are described there are supported by the ANSI standard Structured Query Langauge, meant for database interaction...they are language independant (as noted by Skyhawk) - i.e. they are used in all programming and scripting languages, not just php. It's worth noting, however, that many of the major databases support additonal functions that may be platform specific...this is an example of some.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1