Link Details

Previous | Next

Surprise Me!
Link 79955 thumbnail
User 284459 avatar

By gallard
via codespatter.com
Published: May 08 2008 / 20:22

How to Break a MySQL Left Join
Care must be taken when placing conditions on the results of the right-hand table of a LEFT JOIN because it could easily become a normal JOIN since MySQL is using a NULL row for every column in the right-hand table when no records exist.
Vote up
Vote down
  • 4
  • 0
  • 1071
  • 277
SaveShareSend Tags: ,

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (4)



Voters Against This Link (0)