有一个门店与门店的往来账目记录,自己技术不够想了很多办法都没办法实现。请大家帮忙看看。大致需要这种格式
数据库表
-- ----------------------------
-- Table structure for 221
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[221]') AND type IN ('U'))
DROP TABLE [dbo].[221]
GO
CREATE TABLE [dbo].[221] (
[发卡店铺] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[订单号] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[消费店] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[消费金额] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL
)
GO
ALTER TABLE [dbo].[221] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Records of 221
-- ----------------------------
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'003', N'2024020100210054', N'002', N'266.49')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'001', N'2024020100710132', N'007', N'200.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'012', N'2024020100110064', N'001', N'200.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'001', N'2024020100400079', N'004', N'310.12')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'005', N'2024020100810092', N'008', N'360.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'001', N'2024020101000017', N'010', N'100.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'012', N'2024020100110057', N'001', N'360.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'007', N'2024020101000101', N'010', N'200.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'005', N'2024020102200007', N'022', N'582.30')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'010', N'2024020100900002', N'009', N'450.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'010', N'2024020100900006', N'009', N'2000.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'010', N'2024020100900007', N'009', N'200.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'010', N'2024020100900010', N'009', N'710.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'010', N'2024020100900018', N'009', N'300.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'010', N'2024020100900021', N'009', N'200.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'010', N'2024020100900032', N'009', N'300.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'010', N'2024020100900053', N'009', N'300.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'010', N'2024020100900058', N'009', N'200.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'010', N'2024020100900070', N'009', N'500.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'006', N'2024020101000125', N'010', N'100.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'007', N'2024020101000061', N'010', N'100.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'006', N'2024020101600138', N'016', N'200.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'003', N'2024020100810225', N'008', N'300.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'005', N'2024020100810284', N'008', N'280.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'007', N'2024020101800057', N'018', N'249.00')
GO
INSERT INTO [dbo].[221] ([发卡店铺], [订单号], [消费店], [消费金额]) VALUES (N'002', N'2024020101400176', N'014', N'150.00')