SQL Loader question

[jaxtell]

Hi,
I am trying to use sql loader to import certain records based on if they match any value in a lookup table. Something along the lines of

into table upload_interface_table
when (1:2) = '01' and (60:61) in (select value from common_lookups where ...)

I get the error

SQL*Loader-350: Syntax error at line 34.
Expecting = or "<>", found "in".

Can something like this be done using sql loader, or will I have to use an external table?

Thanks.

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/

 

[Thargy]

Nope, external tables it is - and they're significantly easier to use than sql loader too.

Regards

T