[Dev-sig] Query question for SQL gurus...

[Sean O'Donnell]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sean O'Donnell wrote:
> Sean O'Donnell wrote:
>> Emerson, Tom (*IC) wrote:
> 
> hmm, please ignore my previous message... I have since put down the
> pipe. ;-p
> 
> No, this doesn't work in MySQL either, unfortunately. =/
> 

OK, ignore that one too. It does seem to work in mysql. =)

DELETE FROM test1, test2
USING test1, test2
WHERE (test1.id = 1 AND test2.id = test1.id)

Cheers!

- --

Sean O'Donnell
South Pasadena, CA

sean at seanodonnell.com
http://seanodonnell.com

PGP Public Key ID: 0xF57FB9E5
PGP Public Key Server: http://pgp.mit.edu

*The important thing is not to stop questioning. Curiosity has its own
reason for existing.*


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)

iD8DBQFGwUeACUrh+ax2kDURAvavAKCEiJoMRW4uqbMStMRD5gjvG3q1fQCbBS+A
dIr9qRqTSnP77gRU7TrryEY=
=bCYH
-----END PGP SIGNATURE-----