hello list,
I'm having trouble with an INSERT command based on a select Is what I want is in my contacts table I'm selected certain criteria and then inserting a note into my contactnotes table certain values Here's what I have so far contactnotes mysql table headers: ________________________________________ | | | | code + contactno + note + source + date _____|___________|______|________|______ INSERT INTO contactnotes SELECT code, country, show_qty, completed FROM contacts WHERE country = US AND show_qty = 1 AND completed != 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. Scott Andreas :) IS/Programmer/WebDevelopement Learning Services, Inc. e-mail: [EMAIL PROTECTED] phone: 1-800-877-9378 ext. 146 fax: (541) 744-2056 --- __o --- _-\<,_ --- (_)/ (_) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php