Selecting records based on ID

[eluser]RS71[/eluser]
Interesting.

I've read up on it and it seems that it's somewhat of a 'hack'. I've also read about the method not being very trustworthy and overly complicated.

Is this correct?

[eluser]TheFuzzy0ne[/eluser]
Not that I'm aware of. Where did you read this?

Here's a simple example that may put your mind at ease: http://stackoverflow.com/questions/38549...outer-join

[eluser]RS71[/eluser]
It seems that FULL OUTER JOINs dont exist in MySQL

[eluser]TheFuzzy0ne[/eluser]
Oh... I missed that... Maybe this will help: http://searchenterpriselinux.techtarget....22,00.html

[eluser]kgill[/eluser]
[quote author="TheFuzzy0ne" date="1236884012"]Oh... I missed that... Maybe this will help: http://searchenterpriselinux.techtarget....22,00.html[/quote]

Which suggests: use a union

Ok now that I'm done tweaking fuzzy's nose... Why are you trying to do this - perhaps it's time to step back and ask yourself why you are pursuing this route instead of just using two queries. You intend on handling the data separately, you want different sized fields to be returned for each. Basically any sort of benefit of returning a single result set is going to be offset by the amount of wrangling you're going to have to do to use the data, so unless you have a REALLY huge latency between your web server & your db server what's the compelling reason for doing it?

[eluser]Johan André[/eluser]
[quote author="TheFuzzy0ne" date="1236882481"]
Here's a simple example that may put your mind at ease: http://stackoverflow.com/questions/38549...outer-join[/quote]

Wow, that is really a great example!
If I had seen that when I learned about joins I would have gotten it right away!