连接两个表，“on 子句"中的错误 1054 未知列 [英] join two tables, error 1054 unknown column in 'on clause'

问题描述

我正在尝试通过用户 ID 连接两个表.我试过这个:

I am trying to join two tables by userid. I tried this:

select *
from crm_public.crm_user
join crm_sare.nl_user u on v.userid=u.userid
;

不幸发生错误:错误代码:1054.on 子句"中的未知列v.userid"

我做错了什么?感谢您的帮助.

What did I do wrong? Thanks for your help.

推荐答案

尝试分配别名并确保正确的列名

try assing the alias and be sure of the correct column name

select *
from crm_public.crm_user as v
join crm_sare.nl_user as u on v.userid=u.userid
;

这篇关于连接两个表，“on 子句"中的错误 1054 未知列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！