SELECT
a.CSFC,a.CWO,b.[CRESRCE],b.[CSCAN_TIME]
FROM [CIMOM_BM].[dbo].[TBL_SFC_PRINT_ATTR] a inner join [CIMOM_BM].[dbo].[TBL_SFC_ACTIVITY_LOG] b on a.CSFC = b.CSFC
where a.[CDATETIME_CREATED] >'2020-3-12'
就大概这个样子
...全文
171打赏收藏
SQL 2014 双表查询出来的数据可以行转列吗
SELECT a.CSFC,a.CWO,b.[CRESRCE],b.[CSCAN_TIME] FROM [CIMOM_BM].[dbo].[TBL_SFC_PRINT_ATTR] a inner join [CIMOM_BM].[dbo].[TBL_SFC_ACTIVITY_LOG] b on a.CSFC = b.CSFC where a.[CDATETIME_CREATED] >'2020-3-12' 就大概这个样子