mysql:9786
From: ML account <ML account <ml@xxxxxxxxxx>>
Date: Tue, 06 Jul 2004 23:47:17 +0900
Subject: [mysql 09786] Re: EXCEPT のMysqlで代替方法。
こんにちは。 ML account <ml@xxxxxxxxxx>さんの <20040706143921.457D51AA02E@xxxxxxxxxx> "[mysql 09785] Re: EXCEPTのMysqlで代替方法。" > SELECT table_a.* > FROM table_a LEFT JOIN table_b USING(mail_address) > WHERE table_b.mail_address IS NULL; 論理が逆でしたね。 SELECT table_a.* FROM table_a LEFT JOIN table_b USING(mail_address) WHERE table_b.mail_address IS NOT NULL; 松枝知直 <tomom@xxxxxxxxxx> http://www.argus.ne.jp/~tomom/
9784 2004-07-07 07:33 [<ml_mysql@xxxxxxxxxx] EXCEPT のMysqlで代替方法。 9785 2004-07-06 23:39 ┗[ML account <ml@xxxxx] -> 9786 2004-07-06 23:47 ┣[ML account <ml@xxxxx] 9787 2004-07-07 09:58 ┗[<ml_mysql@xxxxxxxxxx]