emilbarton wrote:
> I wonder which classes of nested SQL requests are not expressible as joins?

I wonder why you want to know this?


Well, anything where you cannot use joins in the first place, such as
UPDATE/DELETE commands:

  DELETE FROM question
  WHERE type_id IN (SELECT id
                    FROM question_type
                    WHERE name LIKE '%homework%')


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to