>>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


or

	
	insert into ClassIn ;
		select * from clients