CreditLogs TABLE(CreditLogId int not null identity(1,1), Credits INT NOT NULL, OccurredOn DATETIME2(7)'2018-02-03', 5, 'BM01') ,(7, '2018-02-03', 30, 'BM02')
,(OccurredOn)
编辑我以前的问题,我简化了(我希望!)我的问题。我们有一张桌子,就像这把小提琴:实际上,我有这个查询的数据:FROM transaction AS t1 FROM transaction as t2
WHERE t2.id_shop_where_transaction_is_done != t1.id_shop_where_tra