[前][次][番号順一覧][スレッド一覧]

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]