mysql 两表数据交叉根据时间显示
select orderId
, productId
, productName
, userId
, productType
, payMoney
, payTime
, orderStatus
, vipPrice
, orderType
,discountsPrice
,create_time
from ((select a.id as orderId
, a.product_id as productId
, a.user_id as userId
,a.product_name as produ.
原创
2021-02-01 16:33:38 ·
270 阅读 ·
0 评论