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 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users