Home > database >  SQL 2014 double table can query the data transfer line column
SQL 2014 double table can query the data transfer line column

Time:09-19


SELECT
Settlement a.C SFC, a.C, b. b. CRESRCE], [CSCAN_TIME]
The FROM [CIMOM_BM] [dbo] [TBL_SFC_PRINT_ATTR] a inner join [CIMOM_BM] [dbo]. [TBL_SFC_ACTIVITY_LOG] b on a.C SFC=biggest SFC
Where a. [CDATETIME_CREATED] & gt; '2020-3-12'




Is probably like this

CodePudding user response:

Line column, there was used in 2005,
But note that the column in the table of results in the end, not in front of,
  • Related