List of Commodities
select distinct cm.broadcommodityname, cm.commoditycode, cm.tickername, lm.commoditycode1givenbyexchange, lm.exbasisdeliverycentre, lm.priceunit from commoditymaster cm inner join commoditylistingmaster lm on cm.commoditycode=lm.commoditycode where lm.exchangecode='NCDEX' and lm.securitycode like '0%' order by cm.broadcommodityname, cm.tickername