sql 语句哪里有错？

fbchenyong 2003-12-11 09:46:42

m_sSQL =" FROM dbo.YT_USER INNER JOIN "
m_sSQL =m_sSQL&" dbo.YT_INFOCONTENT ON dbo.YT_USER.YT_UID = dbo.YT_INFOCONTENT.YT_UID "
m_sSQL =m_sSQL&" where dbo.YT_INFOCONTENT.yt_owneruid in '"& m_uids &"'"
m_sSQL =m_sSQL&" and dbo.YT_INFOCONTENT.yt_iid in '"&m_IIDs&"' and year(dbo.YT_INFOCONTENT.yt_date)='"&year1&"'"
不知道是哪里有错误，应该就是那些引号错误了。请大家帮忙看看，谢谢了。

...全文

99 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

shleo 2003-12-12

打赏
举报

把in换成=

fbchenyong 2003-12-11

打赏
举报

m_sSQL =" select * FROM dbo.YT_USER INNER JOIN "
m_sSQL =m_sSQL&" dbo.YT_INFOCONTENT ON dbo.YT_USER.YT_UID = dbo.YT_INFOCONTENT.YT_UID "
m_sSQL =m_sSQL&" where dbo.YT_INFOCONTENT.yt_owneruid in '"& m_uids &"'"
m_sSQL =m_sSQL&" and dbo.YT_INFOCONTENT.yt_iid in '"&m_IIDs&"' and year(dbo.YT_INFOCONTENT.yt_date)='"&year1&"'"

jacklinchen 2003-12-11

打赏
举报

...and dbo.YT_INFOCONTENT.yt_iid in ("&m_IIDs&") and....

hrh1979 2003-12-11

打赏
举报

m_sSQL =" FROM dbo.YT_USER INNER JOIN "
m_sSQL =m_sSQL & " dbo.YT_INFOCONTENT ON dbo.YT_USER.YT_UID = dbo.YT_INFOCONTENT.YT_UID "
m_sSQL =m_sSQL & " where dbo.YT_INFOCONTENT.yt_owneruid in '" & m_uids & "'"
m_sSQL =m_sSQL & " and dbo.YT_INFOCONTENT.yt_iid in '" & m_IIDs & "' and year(dbo.YT_INFOCONTENT.yt_date)='" & year1 & "'"

& 两边要加空格

shleo 2003-12-11