Combining two tables using perl instead of sql

[hcc]

Dear all:

I have two tables "basic" and "pc" (belong to different tablespaces) that I need to combine into one.

But instead of the following:

select * from basic, pc where pc.staff_id=basic.staff_id(+)

I want to do:

select * from basic
select * from pc

and use Perl to list the result in a form which has every column from "pc" listed and staff_id is checked against "basic" table.

Any hint will be appreciated, thanks in advance.

hc