加入查询不工作 [英] Join Query not Working

问题描述

我试图加入3表这里是我的代码bt它连续显示错误可以任意1识别我的错误

Am trying to join 3 table here is my code bt its showing error continously can any 1 recogonize my error

SELECT        classify11.workclass, classify11.fnlwgt, classify11.Age, classify12.maritalstatus, classify13.education, classify12.workclass AS Expr1, 
                         classify13.workclass AS Expr2
FROM            classify11 INNER JOIN classify12 on classify11.workclass= classify12.workclass
                         classify12 INNER JOIN classify13 on classify12.workclass = classify13.workclass;

错误是

the error is

Msg 102, Level 15, State 1, Line 4
Incorrect syntax near 'classify12'.

谢谢..

Thank You..

推荐答案

它正在工作：你有语法错误。

It is working: you have a syntax error.

SELECT 
classify11.workclass, classify11.fnlwgt, classify11.Age, classify12.maritalstatus, classify13.education, classify12.workclass AS Expr1, classify13.workclass AS Expr2
FROM classify11 
INNER JOIN classify12 on classify11.workclass=classify12.workclass
INNER JOIN classify13 on classify12.workclass = classify13.workclass;

您遇到此错误，因为t这是一个在内部联接之前的表名，并且在条件之后是

..尝试这个...你可以使用表别名....

You encountered this error because there is a Table name before Inner join and after
on condition.. Try this one... you can use table aliases....

SELECT c11.workclass, c11.fnlwgt, c11.Age, c12.maritalstatus,
c13.education, c12.workclass AS Expr1,c13.workclass AS Expr2
FROM classify11 c11
INNER JOIN classify12 c12 on c11.workclass= c12.workclass
INNER JOIN classify13 c13 on c12.workclass = c13.workclass

这篇关于加入查询不工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！