在数据库中可以直接将存储过程返回的结果写入一个临时表里，但是帆软里好像用不了，现在有两个数据集，一个存储过程，怎么将数据集a像sql一样左关联存储过程返回的结果，然后再左关联数据集b，下面是sql

IF OBJECT_ID( 'tempdb..#TempResults' ) IS NOT NULL BEGIN

DROP TABLE # TempResults;

END;

CREATE TABLE # TempResults (

Device VARCHAR ( 160 ),

ASSYLOT VARCHAR ( 160 ),

WaferLot VARCHAR ( 160 ),

WaferID VARCHAR ( 160 ),

TesterNo VARCHAR ( 160 ),

ProberNo VARCHAR ( 160 ) 

);

INSERT INTO # TempResults ( Device, ASSYLOT, WaferLot, WaferID, TesterNo, ProberNo, ) EXEC Proc_STDF_HardBin_Rate_LotSummary @Customer = 'DSWA' SELECT DISTINCT

td.Trackout_Date,

td.Device,

td.PoCustLot,

td.LotID,

rcs.CP_Step,

tk.WaferID,

tr.TestProgram,

tr.TesterNo 

FROM

tD_LotTrackData td

LEFT JOIN RPT_CFG_Step rcs ON td.Step_Code = rcs.MES_Step

LEFT JOIN tD_LotWaferTrack tk ON td.LotID = tk.LotID

LEFT JOIN # TempResults tr ON td.Device = tr.Device 

AND td.PoCustLot = tr.WaferLot 

AND tr.WaferID = tk.WaferID 

WHERE

td.Customer = 'DSWA' 

AND td.Trackout_Date >= DATEADD( WEEK, DATEDIFF( WEEK, 0, GETDATE( ) ) - 1, 0 ) -- 上周的周一

AND td.Trackout_Date < DATEADD( WEEK, DATEDIFF( WEEK, 0, GETDATE( ) ), 0 ) -- 本周的周一