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
2 matches
Mail list logo