mysql 数据关联查询_mysql关联查询出现的数据不准确问题

主要还是自己对sql语句的掌握程度太低了，还需要多多加强sql语句编写，最初我的语句是这样写的：

select orders.aid as oaid ,orders.date as odate,orders.oid,orders.order_number,orders.state as ostate,

orders.total, orders.uid as ouid,

address.addr,address.aid,address.code,address.date as addrdate ,address.`name` as addrname,

address.province,address.region,address.state as addrstate,address.tel,address.uid as addruid,

order_item.order_item_id,order_item.pid as oipid,

order_item.count,order_item.sub_total,order_item.oid as oioid,order_item.date as oidate,

product.pid,product.state as pstate,product.pname,product.pdesc,product.date as pdate,

product.csid,product.market_price,product.shop_price,product.sales,product.stock,

image.image_id,image.name as imgname,image.old_name,image.path,

image.date as imgdate,image.pid as imgpid,image.state as imgstate

from orders

INNER