>>hello!
>>i have two tables and i wanna move some records from 1 table to another so i wanna write
>>

>>select *;
>>from; 
>>mainbase! clients ;
>>where client.id=1; 
>>into table classln;
>>

>>the problem with this Sql i s the table Classln is gonna get re written. can i fit an Append Blank in there somewhere?
>
>
>Check help for SQL INSERT
>
>Agnes
ohhh how does this look..from the top of my head btw

Insert * into classln ;
from mainbase! clients; 
where clients.id=1