Say I have two tables, candies and colors. The colors table holds just code/value pairs like 01 yellow, 02 blue, 03 green, etc. and is referenced in the candies table by code.
How do I query the candies table for all blue candies without an explicit join? For two years now I've been writing these queries with joins, like:
SELECT * FROM candies a JOIN colors o ON(a.color_code = o.color_code)
WHERE o.color_value = 'blue';
I'm certain every time that I'm bringing a gun to a knife fight, but my googling has been fruitless.