Works perfectly, many thanks Martin.
Ian
On 21/01/2011 11:49, Martin.Engelschalk wrote:
> select a.ID
> from a
> join b on b.aID = a.ID
> where b.user = 'MyUser'
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hi,
select a.ID
from a
join b on b.aID = a.ID
where b.user = 'MyUser'
The join is an inner join, so that only rowa of table a are selected
where a rocord in b exists. This seems to be what you want.
Martin
Am 21.01.2011 12:33, schrieb Ian Hardingham:
> Hey guys.
>
> This is just an
Hey guys.
This is just an utterly simple question I know, but I still haven't got
my head around it. I have two tables:
Table A
int ID
Table B
int user
int aID
I need a query which selects all elements of Table A which are "owned"
by a specific user, ie for which there is an entry with
3 matches
Mail list logo