[sorkin2]

While admittedly this could be seen as a mistake in SQL, you can differentiate by looking at whether b.id is NULL or not.

[marcus_holmes]

true, but that's not the point the OP was making, I think :)