I want to extract data into a temporary table such that unique records with the same primary key (in this case an invoice number) are written to one record, with each of the unique fields extracted being written to a separate field in the temporary table record. I have created my temporary table, and a SELECT that pulls out my data, but I can't work out the appropriate syntax to write the unique fields to the invoice record I'm creating. I think I need something like a "while invoice = current value, select..."
I've gone through the documentation, but can't find what I need for the necessary sql. I'd appreciate any assistance. Thanks, Des Dougan --------------------------------------------------------------------- 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
