Index: branches/dev/html/admin/mail/index.php
===================================================================
--- branches/dev/html/admin/mail/index.php	(revision 17)
+++ branches/dev/html/admin/mail/index.php	(revision 11611)
@@ -106,6 +106,4 @@
 
 if($_POST['mode'] == 'delete') {
-	$objQuery = new SC_Query();
-	$objQuery->delete("dtb_customer_mail", "email = ?", array($_POST['result_email']));
 }
 
@@ -140,5 +138,5 @@
 		// ¸¡º÷·ë²Ì¤Î¼èÆÀ
 		$objQuery = new SC_Query();
-		$from = "dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
+		$from = "dtb_customer";
 
 		// ¹Ô¿ô¤Î¼èÆÀ
@@ -167,5 +165,5 @@
 			dtb_customer.tel03,
 			dtb_customer.pref,
-			dtb_customer_mail.mail_flag";
+			dtb_customer.mail_flag";
 		$objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);
 
