Re: [sqlite] Which classes of nested requests are not expressible as joins?

[emilbarton]

Thanks for your answer. I'd like to know to what extent I can convert a Sqlite 
schema to a Mysql one, but I find the question interesting for itself. What if 
we forget about modifying commands and care only about retrieval?


Clemens Ladisch wrote:



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%')
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Which classes of nested requests are not expressible as joins?

[Clemens Ladisch]

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

[sqlite] Which classes of nested requests are not expressible as joins?

[emilbarton]

Hello,

I wonder which classes of nested SQL requests are not expressible as joins? 
Could you answer in non-jargon with examples please?
Thank you in advance (and thank you for Sqlite by the way!).
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users