mysql:4275
From: Tomohiro 'Tomo-p' KATO <Tomohiro 'Tomo-p' KATO <tomop@xxxxxxxxxx>>
Date: Mon, 03 Sep 2001 19:54:46 +0900
Subject: [mysql 04275] Re: ２テーブル間で不一致のデータを抽出したい！
こんばんは、加藤です。 In message "[mysql 04270] ２テーブル間で不一致のデータを抽出したい！", "yasushi fujiwara" <yasushi@xxxxxxxxxx> wrote: >1) >SELECT DISTINCT employee.emp_cd ,employee.last_name_j as name FROM employee INNER JOIN administrators >ON ( (employee.emp_cd <> administrators.emp_cd) >2) >SELECT DISTINCT employee.emp_cd ,employee.last_name_j as name FROM employee, administrators >WHERE ( (employee.emp_cd <> administrators.emp_cd) ) 両方とも問題なく動作しました。 ○環境 ・Vine Linux 2.1.5 ・MySQL-3.23.35 (official SRPMをRAID/BDB有でrebuildしたもの) -- _/_/_/ Tomohiro "Tomo-p" KATO _/_/_/ _/_/_/ e-mail : tomop@xxxxxxxxxx _/_/_/ _/_/_/ http://www.teamgedoh.net/ _/_/_/
4270 2001-09-03 16:18 ["yasushi fujiwara" <] ２テーブル間で不一致のデータを抽出したい！ 4271 2001-09-03 16:54 ┣[<endo_t@xxxxxxxxxx> ] 4272 2001-09-03 17:52 ┣[madara <madara@xxxxx] 4273 2001-09-03 19:39 ┃┗["yasushi fujiwara" <] 4274 2001-09-03 19:54 ┃ ┣[fuji <fujiyama@xxxxx] 4277 2001-09-03 21:49 ┃ ┗[<endo_t@xxxxxxxxxx> ] 4278 2001-09-03 23:02 ┃ ┗["yasushi fujiwara" <] 4289 2001-09-09 08:15 ┃ ┗[<moeru@xxxxxxxxxx> ] 4290 2001-09-10 13:08 ┃ ┣[fuji <fujiyama@xxxxx] 4292 2001-09-10 21:23 ┃ ┃┗[<moeru@xxxxxxxxxx> ] 4293 2001-09-10 22:07 ┃ ┃ ┣[<endo_t@xxxxxxxxxx> ] 4294 2001-09-10 22:19 ┃ ┃ ┣[とみたまさひろ <tomm] 4295 2001-09-10 22:41 ┃ ┃ ┗[fuji <fujiyama@xxxxx] 4298 2001-09-12 00:23 ┃ ┃ ┗[<moeru@xxxxxxxxxx> ] 4291 2001-09-10 13:31 ┃ ┗[madara <madara@xxxxx] -> 4275 2001-09-03 19:54 ┗[Tomohiro 'Tomo-p' KA]