From a961ca32f736027331319d94837f84507ac81df5 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 20 十二月 2024 12:37:34 +0800
Subject: [PATCH] 提交
---
CY_ECommercePlatform/CY.SQLDAL/OA/OA_FukuanshenqingDAL.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_FukuanshenqingDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_FukuanshenqingDAL.cs
index 426c286..ecd4633 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_FukuanshenqingDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_FukuanshenqingDAL.cs
@@ -25,7 +25,7 @@
/// </summary>
const string FROMSOUCEBEFORE = " ( select distinct ok.*, " +
" oe.Name as SupplierName " +
- " from [OA_Fukuanshenqing] ok inner join [OA_Suppliers] oe on oe.Keyid = ok.[SupplierId] " +
+ " from [OA_Fukuanshenqing] ok left join [OA_Suppliers] oe on oe.Keyid = ok.[SupplierId] " +
" where 0=0 ";
--
Gitblit v1.9.1