关于left outer join和*=互换的问题

wenti1976 2009-03-25 03:04:14

加精

strSQL = "select top "+RecordNum+" a.*"+strFiledName+" from t_db_change a,"+TableName+" where 1=1"+strSQL1;
有这么条语句，问下怎样正确用left outer join替换

...全文

751 28 打赏收藏转发到动态举报

写回复

用AI写文章

28 条回复

切换为时间正序

请发表友善的回复…

发表回复

along_861 2011-06-23

打赏
举报

用*=替换left outer join好像sql server 2008不支持

xz33704 2011-04-05

打赏
举报

left outer join 很有用的啊！！！！！

maomaohao3 2009-03-30

打赏
举报

恩不错啊都是高手来着

pcgailxz 2009-03-27

打赏
举报

skyaspnet 2009-03-27

打赏
举报

学习

zxj828282 2009-03-26

打赏
举报

好贴不成

itcrazyman 2009-03-26

打赏
举报

[Quote=引用 3 楼 ws_hgo 的回复:]
strSQL = "select top "+RecordNum+" a.*"+strFiledName+" from t_db_change a,"+TableName+" where 1=1"+strSQL1;

SQL code
strSQL="select top "+RecordNum+" a.*"+strFiledName+" from t_db_change a left join"+TableName T on a.ID=T.ID+" where 1=1"+strSQL1;
[/Quote]
正解

zhangjiaweixt 2009-03-26

打赏
举报

唉，这简单的问题，搞得这复杂啦。。。。真是搞不懂哦。。。。

lovezx1028 2009-03-25

打赏
举报

ding yixia

肥龙上天 2009-03-25

打赏
举报



select top 30 a.*,YWLSH as B1,SJBBH as B2,SPSXBH as B3,SPSXZXBH as B4,YXTYWLSH as B5, 

BJJGZZJGDM as B6,BJJGMC as B7,CONVERT(varchar,BJSJ, 121) as B8, 

BJJG as B9,BLJGMS as B10,ZFTHYY as B11,ZJMC as B12,ZJBH as B13, 

ZJYXQX as B14,FZDW as B15,SFJE as B16,JEDWDM as B17,BZ as B18,BYZDA as B19, 

BYZDB as B20,BYZDC as B21,CONVERT(varchar,BYZDD, 121) as B22,NEOX4MID as B23 

from t_db_change a  left outer join dbo.T_BANJIE  b on a.DEP_value1  = b.ywlsh collate Chinese_PRC_CI_AS

where 1=1 and DEP_tableName='dbo.T_BANJIE' and DEP_RuleFile='n_t_banjie' order by DEP_OID

肥龙上天 2009-03-25

打赏
举报

strSQL = "select top "+RecordNum+" a.*"+strFiledName+" from t_db_change a  "

strSql2 = " left join "+TableName+" b on a.ID = b.ID "



exec (strSql +strSql2)

让你望见影子的墙 2009-03-25

打赏
举报

难道你两个表的排序规则不一样？

wenti1976 2009-03-25

打赏
举报

select top 30 a.*,YWLSH as B1,SJBBH as B2,SPSXBH as B3,SPSXZXBH as B4,YXTYWLSH as B5,
BJJGZZJGDM as B6,BJJGMC as B7,CONVERT(varchar,BJSJ, 121) as B8,
BJJG as B9,BLJGMS as B10,ZFTHYY as B11,ZJMC as B12,ZJBH as B13,
ZJYXQX as B14,FZDW as B15,SFJE as B16,JEDWDM as B17,BZ as B18,BYZDA as B19,
BYZDB as B20,BYZDC as B21,CONVERT(varchar,BYZDD, 121) as B22,NEOX4MID as B23
from t_db_change a left outer join dbo.T_BANJIE b on a.DEP_value1=b.ywlsh
where 1=1 and DEP_tableName='dbo.T_BANJIE' and DEP_RuleFile='n_t_banjie' order by DEP_OID

为什么我这么做了在sql2005中执行报：Msg 468, Level 16, State 9, Line 1
无法解决 equal to 操作中 "Chinese_PRC_CI_AS" 和 "SQL_Latin1_General_CP1_CI_AS" 之间的排序规则冲突。
怎么解决

dawugui 2009-03-25

打赏
举报

[Quote=引用楼主 wenti1976 的帖子:]
strSQL = "select top "+RecordNum+" a.*"+strFiledName+" from t_db_change a,"+TableName+" where 1=1"+strSQL1;
有这么条语句，问下怎样正确用left outer join替换
[/Quote]
太乱了,不知道你什么意思.

sdhdy 2009-03-25

打赏
举报

try:

strSQL = "select top "+RecordNum+" a.*"+strFiledName+" from t_db_change a left outer join "+TableName+" where 1=1"+strSQL1;

jinjazz 2009-03-25

打赏
举报

你都让客户端自定义到这个程度了，表名-字段-条件

还不如让他自己传sql语句了，剩下的非变量的那几个什么select top from之类的没什么实质意义了。

ljluck7687 2009-03-25

打赏
举报

语句中变量太多，完全等价不好写，只写大概：
strSQL = "select top "+RecordNum+" a.*"+strFiledName+" from t_db_change a left outer join "+TableName+" where 1=1"+strSQL1;

ai_li7758521 2009-03-25

打赏
举报

strSQL = "select top "+RecordNum+" a.*,"+strFiledName+" from t_db_change a left join "+TableName+"  b on (连接的条件) where 1=1 "+strSQL1;

让你望见影子的墙 2009-03-25

打赏
举报

strSQL = 'select top '+RecordNum+' a.*'+strFiledName+' from t_db_change a left join '+TableName+' on a.id='+TableName+'.id where 1=1'+strSQL1; 



id表示这两个列要进行连接的列，楼主换成自己 的列

Zoezs 2009-03-25

打赏
举报



strSQL = "select top "+RecordNum+" a.*"+strFiledName+" from t_db_change a,"+TableName+" where 1=1"+strSQL1; 

strSQL = "select top "+RecordNum+" a.*"+strFiledName+" from t_db_change a left join "+TableName+" b on (a表与b表连接的条件) where 1=1"+strSQL1;