如何简化(100分)

树

树熊133

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-08

• #1

如何实现以下的sql语句的功能
select zngoodsource.sourceid,zngoodsource.sourcename,zngoodsource.sourcename,zngoodsource.sourcemail,zngoodsource.sourceadress,zngoodsource.sourcefax,zngoodsource.sourcehuman,zngoodsource.sourceweb，zngoods.goodname from zngoodsource inner join zngoodsourcelist on '+
'zngoodsource.sourceid=zngoodsourcelist.sourceid and zngoodsourcelist.goodid='''+frmgood1.d+'''';
可以简单一点实现吗？

 

S

SuperJS

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-08

• #2

我有一个看上去字少一点的！
SQL:='select a.sourseid,a.sourcename,a.sourcemail,a.sourceadress,a.sourcefax,
a.sourcehuman,a.sourceweb,a.goodname from zngoodsource a,
zngoodsourcelist b where a.sourceid=b.sourceid and b.goodid="'+frmgood1.d+'"';

 

L

lha

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-08

• #3

看类似下面的句子
select a.* from TableLongName a,TableLongName2 b where a.id = b.id

 

B

Brave

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-08

• #4

可以用select a.*,b.dd from table as a inner join talbe2 as b on b.id=a.id

 

D

databox1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-08

• #5

照SuperJS的來吧﹐再提點建議﹕
你每個字段名中都有一個source干什么﹖喜歡打字﹖有共同的就將其名給表名﹐實在沒有必
要在每個Field中加一樣的名字進去。
select a.id,a.name from zngoodsource a where ....
不是看起来很爽？

 

L

liangdewei

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-08

• #6

同意楼上的意见！！

 

W

westboy2000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-08

• #7

这样写吧，能简单一点：
sql.text:='select A.sourceid,A.sourcename,A.sourcename,A.sourcemail,A.sourceadress,A.sourcefax,A.sourcehuman,A.sourceweb,A.goodname '
+'from zngoodsource as A inner join zngoodsourcelist as B on A.sourceid=B.sourceid and B.goodid='''+frmgood1.d+'''';

 

雁

雁孤行

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-28

• #8

多人接受答案了。