>ohhh how does this look..from the top of my head btw
>

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

I think you need to go a bit deeper than top of your head only. You're missing SELECT keyword in this statement. But close enough.

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