Re: [libreoffice-users] LO Base - Question about Query [SOLVED]

Hi Ian,

Glad you got it working - there are often subtle differences between
different flavours of SQL.

If you would like to track down the two blank records, you could try -

SELECT *
FROM `FedSaintsNew`.`Members` `Members`
WHERE `Members`.`Country` = ' '

Not sure what your syntax might be in the last line - if it doesn't work
try -

WHERE `Members`.`Country` = " "

If ever you wanted to know how many people you have from each country, you
could experiment with adding -

, Count(`Members`.`Country`) AS 'Count'
or perhaps -
, Count(`Members`.`Country`) AS "Count"

to the end of your SELECT line.

Noel
--
Noel Lodge
lodgemn@gmail.com


On 25 May 2013 21:10, Ian Whitfield <whitfield@telkomsa.net> wrote:

> Thanks Noel !!!
>
> On 25/05/13 11:58, Marion & Noel Lodge wrote:
>
> > Assuming your field is 'Country', try this -
> >
> >     SELECT Country, Count(Country) AS 'Count'
> >     FROM <your Table name>
> >     GROUP BY Country
> >     ORDER BY Country
> I had a problem, at first - as I always seem to do - with 'Syntax Error'!!
> So I created it with the Wizard and edited it in SQL view.
>
> This resulted in ...
>
> SELECT `Members`.`Country` AS `Country`
> FROM `FedSaintsNew`.`Members` `Members`
> GROUP BY `Members`.`Country`
> ORDER BY `Members`.`Country`
>
> This worked 100%!! So thanks very much. It does bring up two 'Blank'
> results, (which I guess must have a space in them or something). I don't
> know how to track these down but it's not too important.
>
> Appreciate the help.
>
> IanW
> Pretoria RSA
>
> --
> To unsubscribe e-mail to: 
> users+unsubscribe@global.**libreoffice.org<users%2Bunsubscribe@global.libreoffice.org>
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette <http://wiki.documentfoundation.org/Netiquette>
> List archive: 
> http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@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