Thread: outer joins

    #1
  1. No Profile Picture
    PHP Programmer
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    31
    Rep Power
    15
    Are outer joins possible in MySQL? I tried both the *= operator and OUTER JOIN statement. Can someone give me an example on the syntax?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    29
    Rep Power
    0
    Try searching the manual for 'LEFT JOIN', this is the MySQL terminology for an outer join.

Similar Threads

  1. outer joins
    By bigcoder in forum Firebird SQL Development
    Replies: 6
    Last Post: November 20th, 2003, 01:34 PM
  2. Left outer joins
    By rohanm02 in forum MySQL Help
    Replies: 1
    Last Post: October 3rd, 2003, 04:42 AM
  3. Distinct query, outer joins with three tables
    By ericpeeg in forum MySQL Help
    Replies: 9
    Last Post: July 22nd, 2003, 12:09 PM
  4. Left outer joins (since no subqueries)
    By txbakers in forum MySQL Help
    Replies: 4
    Last Post: September 23rd, 2002, 10:38 PM
  5. Outer joins
    By wolfespawn in forum PostgreSQL Help
    Replies: 4
    Last Post: July 29th, 2002, 03:26 PM

IMN logo majestic logo threadwatch logo seochat tools logo