nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

706891_zh-TW

liliconcom

與不使用 JOIN 的函數相比，使用 SQL Join 的 JSL 函數拉取資料行的次數是 3 倍 - 為什麼？

下面的第一個函數使用 SQL INNER JOIN 來提取每個資料行（例如L號) 與下面沒有 JOIN 的第二個函數相比，從資料庫中增加了兩次。我哪裡錯了？

Names Default To Here( 1 );
opnDtb = Function( {R, M, T}, {dtm}, 
 dtm = Open Database(
 "Driver=SQL Server;
 Server=ABCD-EFGH;
 DATABASE=myDB;
    Trusted_Connection=Yes;",
  "SELECT SM.[LNo], SM.[TestDate] AS [orgTestDate], SM.[Median], MT.[EntryDate] AS [TestDate]
      FROM [myDB].[dbo].[P_STD_" || R|| "_" || T || "_" || M || "_SUMMARY] AS SM 
      INNER JOIN [myDB].[dbo].[P_STD_" || R || "_" || T || "_" || M || "_META] AS MT 
      ON SM.LNo =  MT.LNo"
 );
 Return( dtm );
);
////TEST  
clear log (); R  =  "D12"; T = "7"; M = "5"; dtm = opnDtb(R, M, T); dtm << set name ("sTable");

Names Default To Here( 1 );
opnDtb = Function( {R, M, T}, {dtm}, 
 dtm = Open Database(
 "Driver=SQL Server;
 Server=ABCD-EFGH;
 DATABASE=myDB;
    Trusted_Connection=Yes;",
  "SELECT SM.[LNo], SM.[TestDate], SM.[Median] FROM [myDB].[dbo].[P_STD_" || R|| "_" || T || "_" || M || "_SUMMARY] AS SM
 );
 Return( dtm );
);
////TEST  
clear log (); R  =  "D12"; T = "7"; M = "5"; dtm = opnDtb(R, M, T); dtm << set name ("sTable");