On Tue, 2005-03-01 at 13:42 -0800, Scott Frankel wrote:
> [snip problem]
> Task: find all color names in each of palette1's tones.
>
> Can this be done in a single SQL statement?
> [snip table examples]
looks like a job for NATURAL JOIN
test=# select color_name
from palettes
natural join tones
natural join colors
where palette_name='plt1';
color_name
----------------
rose madder
crimson
red ochre
phthalocyanine
leaf green
(5 rows)
gnari
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
