sql - SQL Join Query for Solution for A(Table) selected and B(table) all Record

Question

在此处输入图像描述

SELECT 
    TR.UserKeyCode, TR.ProductID, TR.Line_No 
FROM  
    TBLT_RESULTDTL_DONE TR 
LEFT OUTER JOIN 
    TBLM_PRODUCT TP ON TR.ProductID = TP.ProductID
WHERE  
    TR.UserKeyCode = 'E01_00001' AND TR.QustionID = 1

结果：

 E01_00001  11  1 
 E01_00001  36  2  
 E01_00001  16  3

产品表所有结果和结果记录 3 只有我需要其他人将为空

标签： sqlsql-server

Answer 1

SELECT 
    TR.UserKeyCode, TR.ProductID, TR.Line_No 
FROM  
    TBLM_PRODUCT TP 
LEFT OUTER JOIN 
    TBLT_RESULTDTL_DONE TR ON TR.ProductID = TP.ProductID and  TR.UserKeyCode = 'E01_00001' AND TR.QustionID = 1