Filter table with any value from other table column

Vote count:

0

How to write select in oracle to filter value in one table with any value from other table column.

To be clear, I have two table. For Example Car and Colors.

In Car table I have two columns, car_model and car_color, in Colors table I have col_code and col_color columns.

I need to select all car_model where car_color = any color from col_color column from colors table.

Something like pseudo:

Select car_model From car Where car_color = color.col_color

asked 23 secs ago

Frink

20