>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