本文介绍了一种复杂的 SQL 查询方法，该方法通过多个表之间的内连接操作来筛选特定条件下的数据记录，并确保所获取的数据未被标记为删除状态且为当前有效记录。
SELECT *
FROM UserData INNER JOIN
UserDataJunctions ON UserData.tp_LeafName = UserDataJunctions.tp_LeafName AND UserData.tp_DirName = UserDataJunctions.tp_DirName AND
UserData.tp_SiteId = UserDataJunctions.tp_SiteId INNER JOIN
UserInfo ON UserData.tp_SiteId = UserInfo.tp_SiteID AND UserDataJunctions.tp_Id = UserInfo.tp_ID
WHERE (UserData.tp_DirName like '%Lists/Backup Owner%')AND (UserData.tp_DeleteTransactionId
NOT IN(SELECT DeleteTransactionId FROM dbo.RecycleBin))and tp_IsCurrent=1
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
