Small typo: SELECT * FROM table2 JOIN table1 ON table1.rowid = table2.rowid WHERE table1.name LIKE '%smth%'
-----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Friday, September 14, 2018 1:59 PM To: SQLite mailing list Subject: Re: [sqlite] [SQLITE]select from a table and use its data to select from another one On 14 Sep 2018, at 6:50pm, Maziar Parsijani <maziar.parsij...@gmail.com> wrote: > I have 2 tables with the same rowid now I want to : > select rowid from table1 where table1 like "%smth%" > select * from table2 where rowid =(selected rows before) > > I mean if I could do it in a same query. This is what JOIN is for. SELECT * FROM table2 JOIN table1.rowid = table2.rowid WHERE table1.name LIKE '%smth%' Note that SQLite uses single quotes ' for text strings, not double quotes ". Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users