Joinsが使えなかった話
-
Upload
makoto-henmi -
Category
Technology
-
view
1.039 -
download
2
Transcript of Joinsが使えなかった話
エラーの内容
Mysql2::Error: Table 'DatabaseA.user_details' doesn't exist: SELECT COUNT(*) FROM `users` INNER JOIN `user_details` ON `user_details`.`id` = `users`.`user_id` WHERE `accounts`.`individual_order_flag` = 1 AND (`accounts`.`deleted_at` IS NULL)
エラーの内容
Mysql2::Error: Table 'DatabaseA.user_details' doesn't exist: SELECT COUNT(*) FROM `users` INNER JOIN `user_details` ON `user_details`.`id` = `users`.`user_id` WHERE `accounts`.`individual_order_flag` = 1 AND (`accounts`.`deleted_at` IS NULL)
エラーの内容
Mysql2::Error: Table 'DatabaseA.user_detail' doesn't exist: SELECT COUNT(DISTINCT `users`.`id`) FROM `users` LEFT OUTER JOIN `user_detail` ON `user_details`.`id` = `accounts`.`user_id` WHERE `accounts`.`individual_order_flag` = 1 AND (`accounts`.`deleted_at` IS NULL)