I posted this last weekend, but didn't see it arrive on the list. I'm not sure if this is because the list software doesn't send a copy to posters, but, as I didn't hear from anyone, I'm trying again, so apologies if it has been seen.
I'm fairly new to using MySQL, and need some assistance with a query I'm trying to get to work. I'm testing a SourceForge CRM application called TUTOS, and part of this involves extracting invoice data into OpenOffice so that invoices can be created via a mail-merge. Using OpenOffice's Data Sources feature and MyODBC, I have created a query that pulls the data out. However, each task which goes to make up the invoice is extracted as a separate record on the query output, and hence will end up as a separate invoice document. I would like to, using the invoice number as the key, create a single output record for each invoice with multiple tasks so that I can then write each task to a separate field in the output table for that invoice. I hope this is clear enough, and that someone can give me some help in resolving this. 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