经典sql

来源：互联网发布：mac chrome打不开网页编辑：程序博客网时间：2024/05/02 02:15

                string CmdStr = string.Format(@"SELECT  *FROM    view_use_FileLibWHERE   id IN (        SELECT  id        FROM    use_FileLib        WHERE   tag = '{0}'                AND {1}                AND ownerid = '{2}'        UNION        SELECT  id        FROM    use_FileLib        WHERE   tag = '{0}'                AND {1}                AND EXISTS ( SELECT 1                             FROM   Use_FileShare                                    JOIN dbo.employee ON sharedGroup = department                             WHERE  itemId = use_FileLib.id                                    AND employee.staff_no = '{2}' )        UNION        SELECT  id        FROM    use_FileLib        WHERE   tag = '{0}'                AND {1}                AND guid IN ( SELECT    itemid                              FROM      use_FolderManage                              WHERE     staff_no = '{2}' ) )", TagID, Condition, UserInfo.staff_no);

0 0