insert into from multiply tables problam
insert into from multiply tables problem
im trying to insert to table foo (filed_1 , filed_2 )
from 2 different table something like that :
INSERT INTO foo (Myname ,Sname) values ((SELECT id FROM foo1 WHERE TheName='dodo' ) , (SELECT id FROM foo2 WHERE TheName='dsdsdsdsd' )(
but i keep getting error msg "reserved error (-3025)"
if i run each sub queries it works
but i try to combine them to one it don't