suppose i have 2 tables
Table1
----------------
id1 | id2 | id3
----------------
Table2
----------
id1 | id3
----------
now i want to insert some records
into table 1.
and i have id1 and id2,
but i must get id3 from table2
( means many 'SELECT id3 from table2 WHERE id1=$id1')
is there any easier solution?
Thank you very much.
Table1
----------------
id1 | id2 | id3
----------------
Table2
----------
id1 | id3
----------
now i want to insert some records
into table 1.
and i have id1 and id2,
but i must get id3 from table2
( means many 'SELECT id3 from table2 WHERE id1=$id1')
is there any easier solution?
Thank you very much.