MySQL selecting from multiple tables into a single table

franceslaser

New Member
I have 3 tables.Table A:
TA_ID
TA_NAMETable B:
TB_ID
TB_NAME
TA_IDTABLE C:
TC_ID
TC_NAME
TA_ID
TB_IDI want to insert a name into Table C while getting the id from table A and id from table B, check that these TA_ID and TB_ID match and then insert. How would I do this, could I get a link to a good example?
 
Top