我试图创建一条语句以检索column1 = column0 = 0和column3 = 1的column1,并且我还希望它从column3 = 0和column2 = 1的column1中检索。
这是我的选择语句,但不起作用。我不确定第二个WHERE使用什么子句。
string insertSql = @"SELECT Status from User_friend
WHERE (ProfileId1 = @FriendProfileId)
AND (ProfileId =
(SELECT ProfileId
FROM User_Profile
WHERE UserId = @UserId))
OR
WHERE (ProfileId = @FriendProfileId)
AND (ProfileId1 =
(SELECT ProfileId
FROM User_Profile
WHERE UserId = @UserId))";
叫我疯了,但我认为您只是在寻找“ OR”运算符...
string insertSql = @"SELECT Status from User_friend
WHERE ((ProfileId1 = @FriendProfileId)
AND (ProfileId =
(SELECT ProfileId
FROM User_Profile
WHERE UserId = @UserId))) OR
((ProfileId = @FriendProfileId)
AND (ProfileId1 =
(SELECT ProfileId
FROM User_Profile
WHERE UserId = @UserId)))";
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句