MySQL join rather than subquery

Question

Hey guys I want to something like this:

DELETE FROM ClientsFlags 
WHERE clientId = (SELECT id 
                  FROM Client 
                  WHERE emailRegistrationToken = 3) 
AND flagId = 42;

But with a join rather than the sub query. I'm not very good with joins so please help me out.

What have you tried? See ask advice, please.

John Conde
– John Conde

2013-01-25 12:41:37 +00:00
Commented Jan 25, 2013 at 12:41 — John Conde
– John Conde, Commented Jan 25, 2013 at 12:41

John Woo · Accepted Answer · 2013-01-25 12:43:21Z

1

here is a join version,

DELETE  a
FROM    ClientsFlags a
        INNER JOIN Client b
            ON a.clientId = b.id
WHERE   b.emailRegistrationToken = 3 AND            
        a.flagId = 42;

answered Jan 25, 2013 at 12:43

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Meherzad · Accepted Answer · 2013-01-25 13:24:55Z

1

Try this

Delete C From ClientFlags cf, Client c where cf.lientId=c.Id and email=3 and flagId=42;

answered Jan 25, 2013 at 13:24

Meherzad

8,5611 gold badge33 silver badges40 bronze badges

Comments

Cosmin · Accepted Answer · 2013-01-25 12:44:32Z

0

You should try something like this :

 DELETE C FROM ClientsFlags AS CF
 JOIN Client AS C ON C.Id=CF.clientId 
 WHERE email=3 and flagId=42

answered Jan 25, 2013 at 12:44

Cosmin

2,2141 gold badge23 silver badges39 bronze badges

Collectives™ on Stack Overflow

MySQL join rather than subquery

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related