select tbh.brokerageName, tbh.corpCRDNumber, count(tb.crdNumber) as brokerCount
from tblBrokerageHouses tbh inner join tblBrokers tb on tbh.corpCRDNumber = tb.corpCRDNumber group by tbh.corpCRDNumber order by brokerCount desc;
Stopped at: NYLIFE SECURITIES LLC
http://bb-women.net/sexiest-selfies-of-2014-photo-album
from tblBrokerageHouses tbh inner join tblBrokers tb on tbh.corpCRDNumber = tb.corpCRDNumber group by tbh.corpCRDNumber order by brokerCount desc;
Stopped at: NYLIFE SECURITIES LLC
http://bb-women.net/sexiest-selfies-of-2014-photo-album
No comments:
Post a Comment