Shulou(Shulou.com)06/01 Report--

Group by multi-table multi-field association query

I have a problem, that is, I need the name and quantity of a field at the beginning, but it is the same table.

The database code is as follows:

Select l.batchnumjuncount (l.batchnum) batcount from ts_outphone_list l join ts_outphone_batch b on l.batchnum=b.batchnum left join om_user_list om on l.datamanager=om.login_id left join ts_outphone_supplier tos on tos.id=om.suppliercode where b.ctime > '2014-05-01' and b.ctime'2014-05-01 'and b.ctime

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.