Hi,
Thanks for your answer.I used your answer like this :
SELECT * FROM table2
JOIN table1 on table1.rowid = table2.rowid
WHERE table1.name LIKE '%smth%'
Because without the "table1 on" statement it didn't work .
On Fri, Sep 14, 2018 at 10:29 PM Simon Slavin <slav...@bigfraud.org> wrote:
> 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
