hi,
i'm trying to make a matching table that will map 2 ID's
for example: insert (typeID,stateID)
values (select typeID from types where desc='wait' , select stateID from states where desc='busy')
how do i combine 2 select from different table into 1 new row?
thanks
