Re: sql join question

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