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

Right - none will work with extra space.