Mysql Join条件连接同一服务器中的两个数据库

Question

select first_name, last_name, amount, payment_date 
from customer_db.customer_data c
join employee_db.payment e
on c.customer_id= e.payment_id 
where customer_db.customer_data(customer_id)='6';

我正在获取

12:05:54    select first_name, last_name, amount, payment_date  from customer_db.customer_data c join employee_db.payment e on c.customer_id= e.payment_id  where customer_db.customer_data(customer_id)='6' LIMIT 0, 1000
Error Code: 1305. FUNCTION customer_db.customer_data does not exist 0.000 sec

Answer 1

您正在尝试调用函数:

where customer_db.customer_data(customer_id)='6';
                               ^-----------^

也许你的意思是

where customer_db.customer_data.customer_id='6';
                               ^---

相反？