Thanks Igor, that works, however there is a problem. This will only return a
result when there are no null fields in the last two columns. The first
column has results in every field, but columns 2 and 3 don't have results in
every field. How do I get around this not returning anything when there are
null fields?
Cheers,
Tim.
Igor Tandetnik wrote:
>
> Macgyver7 <t...@buffaloriverforge.com> wrote:
>> Many thanks Igor, that worked beautifully. If I wanted to put the three
>> top
>> meanings in one column separated by commas, instead of three columns, is
>> there an easy way to do that? It would be good to have them in brackets
>> too.
>> eg. (meaning 1, meaning 2, meaning 3)
>
> '(' || (select Meaning ...) || ',' || (select Meaning ...) || ',' ||
> (select Meaning ...) || ')'
>
> --
> Igor Tandetnik
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/Most-Frequent-Occurrence-Problem-tp32900981p32906628.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
