N 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,
t;> 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
>&g
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] [SQLI
ject: Re: [sqlite] [SQLITE]select from a table and use its data to
>select from another one
>
>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 wit
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 wrote:
> On 14 Sep
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 wrote:
> I have 2 tables with the same rowid now I want to :
> select rowid from table1 where table1 like "%smth%"
> select
On 14 Sep 2018, at 6:50pm, Maziar Parsijani 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.
Hi,
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.
___
sqlite-users mailing list
8 matches
Mail list logo