Select b.IMP_EXTID,coalesce(a.Wsortno,0) Wsortno from STOCKACCESSOIRES a join imp_link b on  
a.WLinkedstock = b.WStockid and b.imp_SourceId =<@SOURCEID@>
where a.WStockid = <@WSTOCKID@>