读书人

看一下多谢

发布时间: 2013-09-06 10:17:17 作者: rapoo

看一下,谢谢
我表关联后,为什么报错说有一个字段找不到

在数据库客户端中运行这一段sql后是正常的,就是在java程序中报错,说找不到某一个字段

请高手指点,谢谢
[解决办法]


SELECT `user`.storeName AS storeName,
`user`.ID AS sellerId,
t7.andriodCount AS andriodCount,
t7.updateTime AS updateTime,
t7.appleCount AS appleCount,
t7.appGenTime
FROM (select *
FROM (
select *
FROM (
select *
FROM (
SELECT process_status AS appleCount,
seller_id AS appleSellerId
from seller_apply_request AS re
where request_type='0'
and update_time=(


select MAX(update_time)
from seller_apply_request
where seller_id=re.seller_id
and request_type=re.request_type
GROUP BY seller_id)) AS t1
LEFT JOIN (SELECT process_status AS andriodCount,
seller_id AS androidSellerId
from seller_apply_request AS re
where request_type='1'
and update_time=(


select MAX(update_time)
from seller_apply_request
where seller_id= re.seller_id
and request_type=re.request_type
GROUP BY seller_id)) AS t2
on t1.appleSellerId=t2.androidSellerId) AS t3
LEFT JOIN (
select MAX(update_time) AS updateTime ,
seller_id AS infoSellerId
from seller_app_info


GROUP BY seller_id) AS t4
on t4.infoSellerId=t3.appleSellerId) AS t5
LEFT JOIN (
SELECT MAX(gen_time) AS appGenTime,
seller_id AS genSellerId
from app_gen_info GROUP BY seller_id) AS t6
on t6.genSellerId=t5.appleSellerId) AS t7
LEFT JOIN `user`
on t7.appleSellerId=`user`.ID
ORDER BY updateTime desc

读书人网 >应用服务器

热点推荐