Small typo:
SELECT * FROM table2 JOIN table1
ON table1.rowid = table2.rowid
WHERE table1.name LIKE '%smth%'
-----Original Message-----
From: sqlite-users [mailto:[email protected]] 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 <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
