At 21:21 -0700 9/21/02, Des Dougan wrote: >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.
You're not going to, either. SQL doesn't act according to your description. Well, that's not strictly true. You *can* come up with SQL to do this, but it's going to be along the lines of SQL that generates another SQL statement that you then execute seperately, and it's going to be a huge mess. If you *really* want to do this (that, is create a denormalized result), you're probably better off doing it within the context of a programming language that lets you manipulate the data outside of 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
