> this doesn't work,how should it be done?
> insert into test (uid, companyUid)
> values(1, select uid from companysTable where company = "Micrsoft");

If you are using MySQL, it doesn't support sub selects...

Chris

Reply via email to