Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?

[Adam i Agnieszka Gąsiorowski FNORD aka ALinkA ak a symbol '( { .A. } )'' ||~> { A.A }]

On 2006-05-02, at 08:51, The Nice Spider wrote:

        Wow, impressive pseudonym...Are you
 strong enough to be my man? ;-}

DELETE FROM A
USING A
RIGHT JOIN B ON B.id = A.sectionid
WHERE B.id is null

        ...AND the_reader IS a_fool. Hell and damnation!
 SQL POETRY! :-}

This task is deleted any row in A that have no items
on B.

        Sorry, I'm too sober to parse that :-}}}.{{{-:
 Cheers!

--
she the month of june. A summers' tune
i am forever be, so proud and free and
in the heart of juliette, one love she
won't forget. she longs to be, forever
give. like a child, so pure and wild n
virtuous. she longs to be caused she's

smime.p7s
Description: S/MIME cryptographic signature