>>>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.
If it's not broken, fix it until it is.
My Blog