SQL server多表查询提数

fxsmkj

单表查询
SELECT CardNo,Balance,Stamp
   FROM  dbo.cl_Transactions_2018_05 T
   WHERE not EXISTS
( SELECT CardNo,Balance,Stamp FROM  dbo.cl_Transactions_2018_05 WHERE CardNo = T.CardNo AND Stamp > T.Stamp )

多表查询
SELECT CardNo,Balance,Stamp
   from dbo.cl_Transactions_2022_07,dbo.cl_Transactions_2022_08,dbo.cl_Transactions_2022_09.dbo.cl_Transactions_2022_10,dbo.cl_Transactions_2022_11dbo.cl_Transactions_2022_12,
   dbo.cl_Transactions_2023_01,dbo.cl_Transactions_2023_02,dbo.cl_Transactions_2023_03,dbo.cl_Transactions_2023_04,dbo.cl_Transactions_2023_05,dbo.cl_Transactions_2023_06,dbo.cl_Transactions_2023_07,dbo.cl_Transactions_2023_08,dbo.cl_Transactions_2023_09,dbo.cl_Transactions_2023_10,dbo.cl_Transactions_2023_11,dbo.cl_Transactions_2023_12,
   dbo.cl_Transactions_2024_01,dbo.cl_Transactions_2024_02,dbo.cl_Transactions_2024_03,dbo.cl_Transactions_2024_04,dbo.cl_Transactions_2024_05 T
   where not exists
(SELECT CardNo,Balance,Stamp FROM  dbo.cl_Transactions_2022_07,dbo.cl_Transactions_2022_08,dbo.cl_Transactions_2022_09.dbo.cl_Transactions_2022_10,dbo.cl_Transactions_2022_11dbo.cl_Transactions_2022_12,
   dbo.cl_Transactions_2023_01,dbo.cl_Transactions_2023_02,dbo.cl_Transactions_2023_03,dbo.cl_Transactions_2023_04,dbo.cl_Transactions_2023_05,dbo.cl_Transactions_2023_06,dbo.cl_Transactions_2023_07,dbo.cl_Transactions_2023_08,dbo.cl_Transactions_2023_09,dbo.cl_Transactions_2023_10,dbo.cl_Transactions_2023_11,dbo.cl_Transactions_2023_12,
   dbo.cl_Transactions_2024_01,dbo.cl_Transactions_2024_02,dbo.cl_Transactions_2024_03,dbo.cl_Transactions_2024_04,dbo.cl_Transactions_2024_05 WHERE CardNo = T.CardNo AND Stamp > T.Stamp )

单表查询可行，多表查询不会写，求助完善下
CardNo取多表唯一值，Stamp取多表最新时间