作者ichnoav (...)
看板Database
标题[SQL ] 请问 sql中union语法的使用 (firebird)
时间Wed Sep 12 10:29:33 2012
资料库为
firebird 1.5
我总共有四个table
其中 CUSTOMER 跟 MEMBER 是类似的table
SAL_MASTER 跟 POS_MASTER 是类似的table
第一个语法
======================================================
SELECT first 10 a.CUST_ID as CUST_ID, a.CUST_NAME as CUST_NAME,
sum(b.total_money) AS AMT
FROM CUSTOMER a,SAL_MASTER b
where a.CUST_ID=b.CUST_ID and b.BILL_DATE like '2012/09%'
group by a.CUST_ID, a.CUST_NAME
order by 3 desc
======================================================
第二个语法
======================================================
SELECT first 10 c.MEMBER_ID as CUST_ID, c.MEMBER_NAME as CUST_NAME,
sum(d.SAL_AMT) AS AMT
FROM MEMBER c,POS_MASTER d
where c.MEMBER_ID=d.MEMBER_ID and d.SAL_DATE like '2012/09%'
group by c.MEMBER_ID, c.MEMBER_NAME
order by 3 desc
======================================================
第一个语法选出的table
http://tinyurl.com/9bnufv2
第二个语法选出的table
http://tinyurl.com/8bflc7f
这两个语法都是可以run的
但是union在一起就不行了
我的目标是要把这两个选出来的 union在一起 然後再以AMT这个栏位排序
选出前三名 不知道怎麽写比较好? SQL我不太熟
似乎是 union 跟 group by 跟 order by 有些冲突?
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 60.248.241.217
1F:→ killermomo:union後再order by 试看看 09/12 21:57