select a.`創(chuàng)建日期`,b.`訂單數(shù)`,c.結(jié)算數(shù),d.失效數(shù),e.付款數(shù)
FROM
(SELECT
tkorder.`創(chuàng)建日期`
FROM
tkorder
group by tkorder.`創(chuàng)建日期`) AS a
LEFT JOIN (
SELECT
tkorder.`創(chuàng)建日期`,
count(*) 訂單數(shù)
FROM
tkorder
group by tkorder.`創(chuàng)建日期`
) AS b ON a.`創(chuàng)建日期`= b.`創(chuàng)建日期`
LEFT JOIN (
SELECT
tkorder.`創(chuàng)建日期`,
count(*) 結(jié)算數(shù)
FROM
tkorder where `訂單狀態(tài)`='訂單結(jié)算'
group by tkorder.`創(chuàng)建日期`
) AS c ON a.`創(chuàng)建日期`= c.`創(chuàng)建日期`
LEFT JOIN (
SELECT
tkorder.`創(chuàng)建日期`,
count(*) 失效數(shù)
FROM
tkorder where `訂單狀態(tài)`='訂單失效'
group by tkorder.`創(chuàng)建日期`
) AS d ON a.`創(chuàng)建日期`= d.`創(chuàng)建日期`
的確，網(wǎng)上方法很多，有時(shí)是環(huán)境不同，有時(shí)是測試的方法不正確吧，試了很久才把AdvancedDataGrid上的水印“flex data visualization trial”給去掉
參考資料：http://livedocs.adobe.com/flex/3/html/help.html?content=configuring_environment_2.html
我用的方法是輸入FB3 序列號1377-4260-4983-2510-8542-5740，操作步驟是點(diǎn)擊“Help”--->選擇Manage Flex Bulider Licenses--->輸入序列號
序列號的提供處：http://hi.baidu.com/fanzhene/blog/item/46b7aa511eec612242a75bc7.html