INSERT base on SELECT criteria

date) SELECT '', code, 'show catalog sent to user' , 'catalogs' , '2214' FROM catalogs WHERE country = 'US' AND show_qty = '1' AND completed != '1' What value should in the SELECT statement be so

SQL INSERT based on SELECT CRITERIA

leted != 1 The bulk values that I want to insert into contactnotes are: code = AUTO_INCREMENT contactno = code.contacts <---from the select statement note = Show catalog sent to user source = catalogs date = %Y%M%d All based on the select statement Any help would be appreciated J. S