select storekuaidi.createdatetime,storekuaidi.kuaidisn,storekuaidi.phone,storekuaidi.kuaidiid,storekuaidi.shopid,provider.username,shop.shopname,shop.address from storekuaidi 

INNER JOIN provider

ON storekuaidi.kuaidiid = provider.kuaidiid

INNER JOIN shop

ON storekuaidi.shopid = shop.uid

where provider.kuaidicomid=33 and storekuaidi.state=1