I posted on a related issue in the php forum, then I thought I would as a piece of the question here.
I have two pieces that I'm wondering how to combine into one complete query..
First I query table1 to get the id for several items, found by 2 or 3 columns.
Then I insert a same value into table2 for all those queried id's.
SELECT DISTINCT item_id
WHERE taxonomic_genus = 'Acer' AND scientific_name = 'platanoides' AND infraspecific_epithet = ''
OR taxonomic_genus = 'Alhagi' AND scientific_name = 'maurorum' AND infraspecific_epithet = ''
/*plus another 1000+ or lines after this */
then, once I've got the ids I build this to add the value 423 for each one
those are the two mysql statements I'm hoping to combine.
INSERT INTO table2(item_id, term_id,high_low,male_female)
/* etc for another 1000+ lines */