10 May 2009

LEFT JOIN, RIGHT JOIN

I’ve noticed a very interesting difference between my local development environment and my actual webhosting. In the master post this is the query that displays the artists available (if they have downloads). On my local development environment all the artists keep coming up, while on my webhosting only those with downloads show up (as they should). If I change LEFT JOIN to RIGHT JOIN I reverse the problem. lol.

It’s the same with this query that shows the downloads per artist on the artist page.

What the hell? I have no explanation. haha.

Share on TwitterShare on TumblrSave on Delicious
Leave a reply

Leave a Reply

:grin: :sad: :eek: :confused: :angry: :mad: :P :cry: :evil: :grr: :hoping: :smug: :bawl: :genki: :love: :hearteyes: :huh: :pissedoff: :ill: :mwahaha: :sweatdrop: :kickass: :drool: :wow: :wub: :sleepy: :unsure: :usuck: :victory: :innocent: :yippee: :hoi: :roflmao: :worship: :spank: :puke: :voyeur: :twitch: :fuming: :smokin: :omg: :food: