« previous next »
Pages: [1]

Author Topic: SQL JOIN  (Read 316 times)

0 Members and 1 Guest are viewing this topic.

Offline aeroswatTopic starter

  • Devotee
  • Posts: 848
    • View Profile
SQL JOIN
« on: March 09, 2010, 04:45:10 PM »
Is there something that does what OUTER JOIN does but minus what's in INNER JOIN? I want to be able to get all of the results that don't match anything at all and only those results.
Logged

Offline fenway

  • MySQL Si-Fu / PHP Resident Alien
  • Global Moderator
  • 'Mind Boggling!'
  • *
  • Posts: 15,444
  • Gender: Male
    • View Profile
Re: SQL JOIN
« Reply #1 on: March 15, 2010, 12:47:41 PM »
You mean  LEFT JOIN?
Logged
:anim_rules: Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

Offline aeroswatTopic starter

  • Devotee
  • Posts: 848
    • View Profile
Re: SQL JOIN
« Reply #2 on: March 15, 2010, 01:58:18 PM »
Quote from: fenway on March 15, 2010, 12:47:41 PM
You mean  LEFT JOIN?

Well LEFT JOIN displays everything. I figured a way to do what I wanted anyways. I just through a WHERE field IS NULL in there with my LEFT JOIN. I figured there might be a way to just pull out all non-matching fields with only some sort of JOIN.

Thanks tho :)
Logged
Pages: [1]
« previous next »