如何连接第三个表中单独表中的两列

Please help in solving the following query,

请帮忙解决以下问题,

(
 f.CURS_AMT, c.C_NAME, s.SID FROM COURSE_FEE_DTL f 
 JOIN COURSE_MASTER c ON f.C_CODE = c.C_CODE
 JOIN STUDEDNT_MASTER s ON s. C_NAME = c.C_NAME                      
  )   

When the sp is executed error arises as 'too many arguments specified'

sp执行时出现错误''指定的参数太多'

1 个解决方案

#1

I would guess this is really the full query you need;

我猜这真的是你需要的完整查询;

  SELECT f.CURS_AMT, c.C_NAME, s.SID 
  FROM COURSE_FEE_DTL f 
  JOIN COURSE_MASTER c ON f.C_CODE = c.C_CODE
  JOIN STUDENT_MASTER s ON s.C_NAME = c.C_NAME  

There was no SELECT to begin the query, the mistype @nickd pointed out and a space in the join syntax for the second join.

没有SELECT开始查询,错误类型@nickd指出,第二个连接的连接语法中有一个空格。