SQLite Forum

SELECT question
Login
Ah yes. I also had to remove the reference to 'D'.
<pre>
sqlite> select docs.id, docs.title AS Title, authors.author AS Author, docs.source AS Source,
   ...> (
   ...> select group_concat(keyword)
   ...> from keywords
   ...> where docid = docs.docid
   ...> and authorid = docs.Authorid
   ...> )
   ...> from docs, authors
   ...> where docs.authorid = authors.authorid
   ...> and docs.docid = authors.docid
   ...> order by docs.id desc
   ...> limit 5;
49|Redeeming Charles Babbage's Mechanical Computer|Swade,Doron D.|Scientific American 1993-02|Computer Technology,Engineering,Difference Engine
48|A Partly True Story|Stewart,Ian|Scientific American 1993-02|Mathematics,Fuzzy Logic
47|Alphabet's Now Building Cities|Wright,Emily|Wired 2018-01-02|Smart City,Urban Design
46|The Talented Luthier|Gilchrist,Jim|Scotland Magazine 2021-01|Music - Violin,Luthier,Art
45|Sean Connery|Rowe,Jenny;Adolph,Anthony|Scotland Magazine 2021-01|Sean Connery,Biography,Scottish Ancestry
</pre>