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

Of course, neither of these will fly - there's no space after the !. The exclamation mark is the separator between the database name and the table name. I never saw it work with an embedded space. If it does, I'll scratch my head.