creating temp tables for an export....

[eyetry]

I need to export rows from 6 tables that will be imported to a new DB. The first part of this works fine. I create a temp table from file_config with the appropriate rows...

create table file_config_export
as (select *
from user01.file_config config
where config.business_segment in(403,404,405,406,407,408)
and end_date is null);

The second step is failing. I'm trying to extract data to the next temp table based on column data found in file_config_export.

create table eep_customer_set_export
as (select *
from user01.eep_customer_set eepcs, file_config_export config
where eepcs.eep_customer_set_id config.eep_customer_set_id );

The error message:

where eepcs.eep_customer_set_id config.eep_customer_set_id
*
ERROR at line 4:
ORA-00920: invalid relational operator

Is this a punctuation thing or am I too simple???

I need to export rows from 6 tables that will be imported to a new test environment.....

 

[eyetry]

never mind I see I missed some punctuation. I think my other problem might be autho...