哪个SQL 快
1. --------------------------------------------------------------------------
select v.*
,(CASE WHEN prt.ReportNum <> 0 THEN '是' ELSE '否' END) AS '是否打印'
from v
LEFT JOIN Stuff_IN prt
ON prt.In_ID = v.入库编号
2. --------------------------------------------------------------------------
select v.*
, prt.[是否打印]
from v
LEFT JOIN (SELECT IN_ID, (CASE WHEN ReportNum <> 0 THEN ''是'' ELSE ''否'' END) AS ''是否打印'' FROM Stuff_IN) prt
ON prt.In_ID = v.入库编号
1, 2 哪个快。