SELECT b.*  from 
stock a join STOCK_EXTRA b on a.WSTOCKID = b.WSTOCKID
where a.WStockid = <@WSTOCKID@> 