On Fri, 2 Dec 2011 21:10:54 -0800 (PST), Macgyver7 <t...@buffaloriverforge.com> wrote:
> > I am not sure exactly how I am to work in the coalesce function to get the > result, I tried some experiments and I could get the first and or second > fields in another column, but not as part of the bracketed group. > > This is the argument as it stands now, (without the coalesce function) how > should I introduce the coalesce function to get the desired result? > > SELECT '( ' ||(select English1)|| ', ' ||(select english2)|| ', ' ||(select > english3 )|| ' )' AS English FROM UniqueAramaic4; > > I apologise if this sounds like a silly question, but I am new to SQL and am > trying to get syntax, order and function use straight in my head. What did you try, and how did that fail? The coalesce() function is documented on http://www.sqlite.org/lang_corefunc.html As Igor pointed out, in your SELECT statement replace every occurence of || (select EnglishX) || by || coalesce((SELECT EnglishX FROM table WHERE condition ORDER BY expression LIMIT 1 OFFSET b),'--') || and fill in the actual tablename, condition expression, order by clause and limit clause as discussed before. > Cheers, > Tim. -- Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
