Query 查询多表(带计算字段)究竟如何编写(100分)

L

liuaono1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-03-27

• #1

很多书上提到Query可同时查询多个表,可就是
找不着示例,烦请各位大仙不吝指教,小弟不胜感激!
(愚构思如下,请批改):
select Table1.colum1,SUM(Table1.colum2),Table2.colum1
from "Table1.db"
join "Table2.db"
where ...

 

沈

沈前卫

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-03-27

• #2

select table1.colum1,table1.colum2+table1.colum3,table2.colum1
from "table1.db" table1,"table2.db" table2
where table1.id=table2.id and (....)

 

L

liuaono1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-03-27

• #3

Thanks very much!