any informix high hand here? sql need help here. - Database版

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Database版 - any informix high hand here? sql need help here.

相关主题
● sql high hand please help.	● 请帮我查一段pivot code 错在哪里？
● 问个查询的问题	● How to query a tree
● tbl1.col1 = tbl2.col2 (+)	● SQL问题请教
● 再来一个SQL Server的面试题	● How to get other columns after UNION?
● PIVOT, 请大拿，帮我debug	● SQL Server query 一问
● 我的这句MySQL哪里错了吗？	● 弱问 mysql 的 sql
● change year format in Access by SQL query (转载)	● 求教：怎么在select 出的结果里加一行
● error of sql query in MS Access database (转载)	● union function differenct between sql server 2005 and 2008?

相关话题的讨论汇总
话题: select话题: informix话题: here话题: syntax话题: price

进入Database版参与讨论

(共1页)

w******n
发帖数: 15

SELECT avg(price) FROM (SELECT price
FROM motel UNION SELECT price FROM resorts)
i got this to work in access but just
not in informix always get 201 syntax error.
any idea what's wrong with this? where syntax error
comes from????

(共1页)

进入Database版参与讨论

相关主题
● union function differenct between sql server 2005 and 2008?	● PIVOT, 请大拿，帮我debug
● 请问这个update query有什么问题？	● 我的这句MySQL哪里错了吗？
● 求教个MS SQL的问题	● change year format in Access by SQL query (转载)
● Oracle 11g坑爹还是公司DBA坑爹	● error of sql query in MS Access database (转载)
● sql high hand please help.	● 请帮我查一段pivot code 错在哪里？
● 问个查询的问题	● How to query a tree
● tbl1.col1 = tbl2.col2 (+)	● SQL问题请教
● 再来一个SQL Server的面试题	● How to get other columns after UNION?

相关话题的讨论汇总
话题: select话题: informix话题: here话题: syntax话题: price

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

boards

未名新帖统计// 7月16日

历史上的今天