sql(0分)

L

liminhan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-09

• #1

如何在select中引用，从table1选择到的列（值有多个）作表名称，
select * from (select field0 from table1 where month=12) where name=111;
而且，引用query控件，table1的字段为字符型，如何写？
query1.sql.add('select* from table1 where month='+''''+12+'''');
不成功。

 

L

llliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-09

• #2

啥意思

 

一

一生中最爱

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-15

• #3

query1.sql.add('select* from table1 where month=12');
query1.sql.add('select* from table1 where month='+'12');
对select * from (select field0 from table1 where month=12) where name=111
一般分开写，导个临时表，没必要非的写在一起。

 

L

liminhan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-03-20

• #4

接受答案了.