Hi,

I'm trying to create a table using the result set from a query on
another table, but can't figure out where I've gone wrong:

create Table "_Tmp2" as
select distinct T.Field1, T.Field2, T.Field3
From _TMP T

I've also tried as a script:

SCRIPT
BEGIN
EXECUTE IMMEDIATE'
create Table "_Tmp2" as
select distinct T.Field1, T.Field2, T.Field3
From _TMP T';
END;

Both times I get the error #700 (Missing WITH)

I know it's simple, but I guess I'm still stuck in DBISam's Select ...
into methods.

Cheers

Adam.

Adam

create Table "_Tmp2" as
select distinct T.Field1, T.Field2, T.Field3
From _TMP T

WITH DATA

Roy Lambert [Team Elevate]

Oh Roy - is that it. I feel like such a noob!

Thanks for your help!

Adam.

> Adam
>
> create Table "_Tmp2" as
> select distinct T.Field1, T.Field2, T.Field3
>  From _TMP T
>
> WITH DATA
>
> Roy Lambert [Team Elevate]
>

How about using

create Table "_Tmp2" like
"TMP T"


"Adam H." <ahairsub5@removeme.jvxp.com> wrote in message
news:085241B5-E338-489E-8367-734378999AE0@news.elevatesoft.com...
> Oh Roy - is that it. I feel like such a noob!
>
> Thanks for your help!
>
> Adam.
>
>> Adam
>>
>> create Table "_Tmp2" as
>> select distinct T.Field1, T.Field2, T.Field3
>>  From _TMP T
>>
>> WITH DATA
>>
>> Roy Lambert [Team Elevate]
>>
>