> SELECT moz_places.id, moz_places.url, moz_places.title, moz_bookmarks.parent
> FROM moz_places, moz_bookmarks
> WHERE moz_places.id = moz_bookmarks.fk
> and moz_bookmarks.parent = (select id
> from moz_bookmarks
> where title like '%arbeit%')
Firstly, are you sure you shouldn't be saying IN rather that = ?
SELECT moz_places.id, moz_places.url, moz_places.title, moz_bookmarks.parent
FROM moz_places, moz_bookmarks
WHERE moz_places.id = moz_bookmarks.fk
and moz_bookmarks.parent = (select id
from moz_bookmarks
where title like '%arbeit%' limit 1)
Is what is actually being processed.
If the id of the one row (selected by happenchance) satisfying the constraint
in the subquery does not happen to have any rows where that id is used in the
parent column, you will get no result rows at all.
You probably mean something like:
SELECT moz_places.id, moz_places.url, moz_places.title, moz_bookmarks.parent
FROM moz_places, moz_bookmarks
WHERE moz_places.id = moz_bookmarks.fk
and moz_bookmarks.parent IN (select id
from moz_bookmarks
where title like '%arbeit%')
which will return results if ANY of the selected id are used in the parent
column, rather than requiring that only the happenchance selected id be used in
the parent column.
---
() ascii ribbon campaign against html e-mail
/\ www.asciiribbon.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
