Re: Creating table

[Patricio Calderon]

Thank you Peter, that worked out well. The reason why I included the cursor was because I wanted to make the process of updating the test_t1 table, based on the base select statement, automatically. Would your example work if I create a select statement with multiple subqueries?

Thanks,

Patricio

Peter Brawley Wrote:
-------------------------------------------------------
> What's the point of the cursor? Why not just
> something like ...
>
> drop table if exists test_t1;
> create table test_t1
> (id_participant varchar(11), first_name
> varchar(45), date_interview date);
>
> insert into test_t1
> select distinct a.id_participant, a.first_name,
> b.date_interview
> from
> participants a
> join master_interviews b on a.id_participant =
> b.participants_id_participant;