在线等,求一个SQL的写法,谢谢
SELECT *, dbo.project.project_name_jiancheng FROM dbo.project_Adjust INNER JOIN dbo.project ON dbo.project_Adjust.project_id = dbo.project.project_ID
我还有一个users表,我需要将project_Adjust表里面的users_id和users表里面users_id关联起来,用来取得users_name表的内容,如果象上面的ON dbo.project_Adjust.project_id = dbo.project.project_ID方式关联,则取得数据会缺少,我怎么写这个语句,让他在上面的sql基础上关联到users这个表,在线急等