Hi :)
Thanks guys :) Ok, so i am starting out with the embedded database against all
advice but just so that i can keep emailing it to myself easily until i get to
grips with it better. Then i hope to export this table to whatever small
back-end seems best. My Sql coding gets rejected "Syntax error in SQL
expression" and then these "SQL Status: HY000 Error code: 1000 Syntax error
in SQL expression"
"SQL Status: HY000 Error code: 1000"
"SQL Status: HY000 Error code: 1000 syntax error, unexpected $end,
expecting BETWEEN or IN or SQL_TOKEN_LIKE"
Here's 'my' code
INSERT INTO OrgTable
("IdOfOrg", "IdOfPerson", "OrgName")
SELECT ("IdOfOrg", "IdOfPerson", "OrgName")
FROM "zzQuery1"
WHERE OrgName IS NOT NULL;
Regards from
Tom :)
>________________________________
> From: Alex Thurgood <[email protected]>
>To: [email protected]
>Sent: Friday, 11 January 2013, 20:46
>Subject: [libreoffice-users] Re: Base: Action Queries
>
>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: [email protected]
>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
>
>
>
>
--
For unsubscribe instructions e-mail to: [email protected]
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
