Le 11/01/2013 21:28, Tom Davies a écrit : Hi Tom,
I've exported a tiny part of the data, and ended up with 2 columns ClientID CompanyName Not all clients have a company name so there are a lot of blanks in the 2nd column. I've written a query to just show the non-blanks (=non-nulls) but now i want to make that into a table in it's own right. Is there an easy way to get a query to create the table for me or should i export as a Csv?
This might help http://www.techonthenet.com/sql/insert.php using INSERT ... SELECT Alex -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted