Help me build the SQL query for this one.

[tishri clarin]

Hi,

Please help me build this query.


id description
1 valueA
2 valueA
3 valueA
4 valueB


result should be stored on a table or a temporary table like this
[table1 and table2] are related via primary key [id]


[Table1]
id description
1 valueA
2 valueB


[Table2]
id ids
1 1
1 2
1 3
2 4

Thanks