查询

select distinct a.stockscode,a.stockName,c.Boardname from  BoardStock as a,BoardName as b,Boarddata as c where a.classid='3' and a.Bardstockid=c.url