一个关于SQL的问题，在线等！！！谢谢！！！！(0分)

那位大侠帮帮忙啊：
select pdddf from dprice where lbname like '农村%'

select name,totalctgd,je,psxf,pfjf,pdjf from zjf
where kbookno=281 and yea=2006 and mon=2 and (typeid=44 or typeid=45 or typeid=46)

将这两个语句合并成一条语句取出pdddf，name,totalctgd,je,psxf,pfjf,pdjf

select zjf.name,zjf.totalctgd,zjf.je,zjf.psxf,zjf.pfjf,zjf.pdjf,dprice.pdddf from zjf,dprice where *************

这两张表有联系吗?

寒战：
你好！
select pdddf from dprice where lbname like '农村%'
go 结果如下：
1 1.1628
2 0.7658
3 0.4358

select name,totalctgd,je,psxf,pfjf,pdjf from zjf
where kbookno=281 and yea=2006 and mon=2 and (typeid=44 or typeid=45 or typeid=46)

go 结果如下：
1188.000 1957.640 15.444 0.000 23.760
692.000 747.450 8.996 0.000 13.840
692.000 420.890 8.996 0.000 13.840
我只要三行记录，结果出来很多行，如何解决？？？谢谢！！！

select zjf.name,zjf.totalctgd,zjf.je,zjf.psxf,zjf.pfjf,zjf.pdjf,dprice.pdddf from zjf,dprice where zjf.kbookno=281 and zjf.yea=2006 and zjf.mon=2 and (zjf.typeid=44 or zjf.typeid=45 or zjf.typeid=46) and dprice.lbname like '农村%'
试下~不太清楚你的表结构,而且你想要的结果是什么

typeid=44对应的是1.1628
typeid=45对应的是0.7658
typeid=46对应的是0.4358
我要的结果是
totalctgd je psxf pfjf pdjf pdddf
1188.000 1957.640 15.444 0.000 23.760 1.1628
692.000 747.450 8.996 0.000 13.840 0.7658
692.000 420.890 8.996 0.000 13.840 0.4358
我自己写的语句：
select z.totalctgd,z.je,z.psxf,z.pfjf,z.pdjf ,d.pdddf from zjf z ,dprice d
where z.kbookno=281 and z.yea=2006 and z.mon=2 and (z.typeid=44 or z.typeid=45 or z.typeid=46) and lbname like '农村%'
执行后返回的是9行，我需要的是三行。

条件是不是判断有误,九行里面的pdddf 是不是都是1.1628 0.7658 0.4358

我重新写的
select eta.xl_id,zjf.name,zjf.et_id,zjf.totalctgd,zjf.je,zjf.psxf,zjf.pfjf,zjf.pdjf ,dprice.pdddf from zjf ,dprice,eta
where zjf.kbookno=281 and zjf.yea=2006 and zjf.mon=2 and dprice.lbname like '农村%'
and (zjf.typeid=44 or zjf.typeid=45 or zjf.typeid=46)
and (eta.typeid=44 or eta.typeid=45 or eta.typeid=46)
and (dprice.typeid=44 or dprice.typeid=45 or dprice.typeid=46)
and (eta.typeiddj=1.1628 or eta.typeiddj=0.7658 or eta.typeiddj=0.4538)
and (dprice.pdddf=1.1628 or dprice.pdddf=0.7658 or dprice.pdddf=0.4538)
group by eta.xl_id,zjf.name,zjf.et_id,zjf.totalctgd,zjf.je,zjf.psxf,zjf.pfjf,zjf.pdjf ,dprice.pdddf
go 结果是
夏店窑厂 1010 1188.000 1957.640 15.444 0.000 23.760 0.7658
夏店窑厂 1010 1188.000 1957.640 15.444 0.000 23.760 1.1628
夏店窑厂 1011 692.000 747.450 8.996 0.000 13.840 0.7658
夏店窑厂 1011 692.000 747.450 8.996 0.000 13.840 1.1628
夏店窑厂 1012 692.000 420.890 8.996 0.000 13.840 0.7658
夏店窑厂 1012 692.000 420.890 8.996 0.000 13.840 1.1628

我要的结果是：
et_id totalctgd je psxf pfjf pdjf pdddf
1010 1188.000 1957.640 15.444 0.000 23.760 1.1628
1011 692.000 747.450 8.996 0.000 13.840 0.7658
1012 692.000 420.890 8.996 0.000 13.840 0.4358

1010对应的是1.1628
1011对应的是0.7658
1012对应的是0.4358

你用了模糊查询,所以会有重复的
看你的结果
对掉重复的就可以了
不过你的语句写的是不是太复杂了一点~

应该不会太难
把你的表结构贴出来,用到的几张表,
我帮你把SQL语句写了来看看

use [tdfdb]
GO

CREATE TABLE [dbo].[dprice] (
[typeid] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[zhuno] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[lbname] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[pdddf] [numeric](5, 4) NOT NULL ,
[pjbdj] [numeric](5, 3) NULL ,
[pdlzj1] [numeric](5, 3) NULL ,
[pdlzj2] [numeric](5, 3) NULL ,
[pgjf] [numeric](5, 3) NULL ,
[pfjf] [numeric](5, 3) NULL ,
[pdjf] [numeric](5, 3) NULL ,
[pndf] [numeric](5, 3) NULL ,
[pdwf] [numeric](5, 3) NULL ,
[psxf] [numeric](5, 3) NULL ,
[pymf] [numeric](5, 3) NULL ,
[pqt1] [numeric](5, 4) NULL ,
[pqt2] [numeric](5, 3) NULL ,
[ydgl] [char] (8) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[dprice] WITH NOCHECK ADD
CONSTRAINT [DF_dprice_zhuno] DEFAULT (0) FOR [zhuno],
CONSTRAINT [PK_dprice] PRIMARY KEY NONCLUSTERED
(
[typeid]
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[zjf] (
[userid] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[et_id] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[yea] [int] NULL ,
[mon] [int] NULL ,
[typeid] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[otherid] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[lastctgd] [numeric](13, 3) NULL ,
[currctgd] [numeric](13, 3) NULL ,
[fbdd] [numeric](13, 3) NULL ,
[dbs] [numeric](13, 3) NULL ,
[totalctgd] [numeric](13, 3) NULL ,
[fld1] [numeric](13, 3) NULL ,
[fld2] [numeric](13, 3) NULL ,
[fld3] [numeric](13, 3) NULL ,
[fld4] [numeric](13, 3) NULL ,
[gdtype1] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[gdtype2] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[gdtype3] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[gdtype4] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[ftfld1] [numeric](13, 3) NULL ,
[ftfld2] [numeric](13, 3) NULL ,
[ftfld3] [numeric](13, 3) NULL ,
[ftfld4] [numeric](13, 3) NULL ,
[fttype1] [numeric](13, 3) NULL ,
[fttype2] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[fttype3] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[fttype4] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[je] [numeric](13, 3) NULL ,
[wyj] [numeric](13, 3) NULL ,
[fks] [numeric](13, 3) NULL ,
[yfwyj] [numeric](13, 3) NULL ,
[if_fq] [bit] NOT NULL ,
[pdlzj1] [numeric](13, 3) NULL ,
[pdlzj2] [numeric](13, 3) NULL ,
[pgjf] [numeric](13, 3) NULL ,
[pdwf] [numeric](13, 3) NULL ,
[pndf] [numeric](13, 3) NULL ,
[psxf] [numeric](13, 3) NULL ,
[pymf] [numeric](13, 3) NULL ,
[pfjf] [numeric](13, 3) NULL ,
[pqt1] [numeric](13, 3) NULL ,
[pqt2] [numeric](13, 3) NULL ,
[pjbdj] [numeric](13, 3) NULL ,
[pdjf] [numeric](13, 3) NULL ,
[hn] [numeric](13, 3) NULL ,
[cdwyj] [numeric](13, 3) NULL ,
[cddf] [numeric](13, 3) NULL ,
[if_fp] [bit] NOT NULL ,
[if_dy] [bit] NOT NULL ,
[dj] [numeric](13, 3) NULL ,
[fk_date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[shouwyj] [numeric](13, 3) NULL ,
[zbdf] [numeric](13, 3) NULL ,
[addje] [numeric](13, 3) NULL ,
[lv] [numeric](13, 3) NULL ,
[lvnum] [numeric](13, 3) NULL ,
[lvd] [numeric](13, 3) NULL ,
[lvdf] [numeric](13, 3) NULL ,
[bys] [numeric](13, 3) NULL ,
[bys1] [numeric](13, 3) NULL ,
[bys2] [numeric](13, 3) NULL ,
[hybm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[xs] [numeric](13, 3) NOT NULL ,
[wgdl] [numeric](13, 3) NOT NULL ,
[wgsh] [numeric](13, 3) NOT NULL ,
[if_jz] [bit] NOT NULL ,
[fph] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[kbookno] [int] NULL ,
[kpageno] [int] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[zjf] WITH NOCHECK ADD
CONSTRAINT [DF__zjf__lastctgd__54968AE5] DEFAULT (0) FOR [lastctgd],
CONSTRAINT [DF__zjf__currctgd__558AAF1E] DEFAULT (0) FOR [currctgd],
CONSTRAINT [DF__zjf__fbdd__567ED357] DEFAULT (0) FOR [fbdd],
CONSTRAINT [DF__zjf__dbs__5772F790] DEFAULT (0) FOR [dbs],
CONSTRAINT [DF__zjf__totalctgd__58671BC9] DEFAULT (0) FOR [totalctgd],
CONSTRAINT [DF__zjf__fld1__595B4002] DEFAULT (0) FOR [fld1],
CONSTRAINT [DF__zjf__fld2__5A4F643B] DEFAULT (0) FOR [fld2],
CONSTRAINT [DF__zjf__fld3__5B438874] DEFAULT (0) FOR [fld3],
CONSTRAINT [DF__zjf__fld4__5C37ACAD] DEFAULT (0) FOR [fld4],
CONSTRAINT [DF__zjf__ftfld1__5D2BD0E6] DEFAULT (0) FOR [ftfld1],
CONSTRAINT [DF__zjf__ftfld2__5E1FF51F] DEFAULT (0) FOR [ftfld2],
CONSTRAINT [DF__zjf__ftfld3__5F141958] DEFAULT (0) FOR [ftfld3],
CONSTRAINT [DF__zjf__ftfld4__60083D91] DEFAULT (0) FOR [ftfld4],
CONSTRAINT [DF__zjf__je__60FC61CA] DEFAULT (0) FOR [je],
CONSTRAINT [DF__zjf__wyj__61F08603] DEFAULT (0) FOR [wyj],
CONSTRAINT [DF__zjf__fks__62E4AA3C] DEFAULT (0) FOR [fks],
CONSTRAINT [DF__zjf__yfwyj__63D8CE75] DEFAULT (0) FOR [yfwyj],
CONSTRAINT [DF__zjf__if_fq__64CCF2AE] DEFAULT (0) FOR [if_fq],
CONSTRAINT [DF__zjf__pdlzj1__65C116E7] DEFAULT (0) FOR [pdlzj1],
CONSTRAINT [DF__zjf__pdlzj2__66B53B20] DEFAULT (0) FOR [pdlzj2],
CONSTRAINT [DF__zjf__pgjf__67A95F59] DEFAULT (0) FOR [pgjf],
CONSTRAINT [DF__zjf__pdwf__689D8392] DEFAULT (0) FOR [pdwf],
CONSTRAINT [DF__zjf__pndf__6991A7CB] DEFAULT (0) FOR [pndf],
CONSTRAINT [DF__zjf__psxf__6A85CC04] DEFAULT (0) FOR [psxf],
CONSTRAINT [DF__zjf__pymf__6B79F03D] DEFAULT (0) FOR [pymf],
CONSTRAINT [DF__zjf__pfjf__6C6E1476] DEFAULT (0) FOR [pfjf],
CONSTRAINT [DF__zjf__pqt1__6D6238AF] DEFAULT (0) FOR [pqt1],
CONSTRAINT [DF__zjf__pqt2__6E565CE8] DEFAULT (0) FOR [pqt2],
CONSTRAINT [DF__zjf__pjbdj__6F4A8121] DEFAULT (0) FOR [pjbdj],
CONSTRAINT [DF__zjf__pdjf__703EA55A] DEFAULT (0) FOR [pdjf],
CONSTRAINT [DF__zjf__cdwyj__7132C993] DEFAULT (0) FOR [cdwyj],
CONSTRAINT [DF__zjf__cddf__7226EDCC] DEFAULT (0) FOR [cddf],
CONSTRAINT [DF__zjf__if_fp__731B1205] DEFAULT (0) FOR [if_fp],
CONSTRAINT [DF__zjf__if_dy__740F363E] DEFAULT (0) FOR [if_dy],
CONSTRAINT [DF__zjf__dj__75035A77] DEFAULT (0) FOR [dj],
CONSTRAINT [DF__zjf__shouwyj__75F77EB0] DEFAULT (0) FOR [shouwyj],
CONSTRAINT [DF__zjf__zbdf__76EBA2E9] DEFAULT (0) FOR [zbdf],
CONSTRAINT [DF__zjf__addje__77DFC722] DEFAULT (0) FOR [addje],
CONSTRAINT [DF__zjf__lv__78D3EB5B] DEFAULT (0) FOR [lv],
CONSTRAINT [DF__zjf__lvnum__79C80F94] DEFAULT (0) FOR [lvnum],
CONSTRAINT [DF__zjf__lvd__7ABC33CD] DEFAULT (0) FOR [lvd],
CONSTRAINT [DF__zjf__lvdf__7BB05806] DEFAULT (0) FOR [lvdf],
CONSTRAINT [DF__zjf__bys__7CA47C3F] DEFAULT (0) FOR [bys],
CONSTRAINT [DF__zjf__bys1__7D98A078] DEFAULT (0) FOR [bys1],
CONSTRAINT [DF__zjf__bys2__7E8CC4B1] DEFAULT (0) FOR [bys2],
CONSTRAINT [DF__zjf__xs__7F80E8EA] DEFAULT (0) FOR [xs],
CONSTRAINT [DF__zjf__wgdl__00750D23] DEFAULT (0) FOR [wgdl],
CONSTRAINT [DF__zjf__wgsh__0169315C] DEFAULT (0) FOR [wgsh],
CONSTRAINT [DF__zjf__if_jz__025D5595] DEFAULT (0) FOR [if_jz],
CONSTRAINT [DF_zjf_kbookno] DEFAULT (0) FOR [kbookno],
CONSTRAINT [DF_zjf_kpageno] DEFAULT (0) FOR [kpageno],
CONSTRAINT [IX_zjf] UNIQUE NONCLUSTERED
(
[userid],
[et_id],
[yea],
[mon]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[eta] (
[userid] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[et_id] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[et_add] [char] (32) COLLATE Chinese_PRC_CI_AS NULL ,
[bds_id] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[tq_id] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[xl_id] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[typeid] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[et_a] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[et_h] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[et_ty] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[et_n] [numeric](13, 3) NULL ,
[et_m] [char] (32) COLLATE Chinese_PRC_CI_AS NULL ,
[et_rek] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ctgd0] [numeric](13, 3) NULL ,
[w808590] [int] NULL ,
[ctgd2] [numeric](13, 3) NULL ,
[lastctgd] [numeric](13, 3) NULL ,
[currctgd] [numeric](13, 3) NULL ,
[fbdd] [numeric](13, 3) NULL ,
[guding] [numeric](13, 3) NULL ,
[vt] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[vn] [numeric](13, 3) NULL ,
[vl] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[vh] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[vm] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ht] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[hn] [numeric](13, 3) NULL ,
[hm] [char] (32) COLLATE Chinese_PRC_CI_AS NULL ,
[hh] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ht2] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[hn2] [numeric](13, 3) NULL ,
[hm2] [char] (32) COLLATE Chinese_PRC_CI_AS NULL ,
[hh2] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[bu_nam] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[curid] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[dbslb] [numeric](13, 3) NULL ,
[tslb] [numeric](13, 3) NULL ,
[xslb] [numeric](13, 3) NULL ,
[addje] [numeric](13, 3) NULL ,
[tctgd] [numeric](13, 3) NULL ,
[totalctgd] [numeric](13, 3) NULL ,
[hybm] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[djxs1] [numeric](13, 3) NULL ,
[djxs2] [numeric](13, 3) NULL ,
[djxs3] [numeric](13, 3) NULL ,
[djxs4] [numeric](13, 3) NULL ,
[fttype1] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[fttype2] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[fttype3] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[fttype4] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[fld1] [numeric](13, 3) NULL ,
[fld2] [numeric](13, 3) NULL ,
[fld3] [numeric](13, 3) NULL ,
[fld4] [numeric](13, 3) NULL ,
[gdtype1] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[gdtype2] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[gdtype3] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[gdtype4] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[cbqno] [int] NULL ,
[kbookno] [int] NULL ,
[kpageno] [int] NULL ,
[dianya] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[otherid] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[typeid0] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[cor_userid] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[if_fenlei] [bit] NOT NULL ,
[if_1] [bit] NOT NULL ,
[if_blxs] [bit] NOT NULL ,
[if_man] [bit] NOT NULL ,
[if_cor] [bit] NOT NULL ,
[if_guding] [bit] NOT NULL ,
[if_other] [bit] NOT NULL ,
[if_dy] [bit] NOT NULL ,
[if_del] [bit] NOT NULL ,
[if_bys] [bit] NOT NULL ,
[if_xs1] [bit] NOT NULL ,
[if_xs] [bit] NOT NULL ,
[if_dbs] [bit] NOT NULL ,
[yjd] [int] NULL ,
[xs] [numeric](13, 3) NULL ,
[name] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[if_cb] [bit] NOT NULL ,
[hbdl] [numeric](13, 3) NULL ,
[typeiddj] [numeric](13, 4) NULL ,
[otheriddj] [numeric](13, 4) NULL ,
[ftdj1] [numeric](13, 4) NULL ,
[ftdj2] [numeric](13, 4) NULL ,
[ftdj3] [numeric](13, 4) NULL ,
[ftdj4] [numeric](13, 4) NULL ,
[gddj1] [numeric](13, 4) NULL ,
[gddj2] [numeric](13, 4) NULL ,
[gddj3] [numeric](13, 4) NULL ,
[gddj4] [numeric](13, 4) NULL ,
[if_zs] [bit] NOT NULL ,
[if_sub] [bit] NOT NULL ,
[sub_userid] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[subdl] [numeric](13, 3) NULL ,
[danganid] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[et_cb] [numeric](13, 3) NULL ,
[addtype] [int] NULL ,
[cortype] [int] NULL ,
[if_nypg] [bit] NOT NULL ,
[jbstr] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[if_jb] [bit] NOT NULL ,
[if_gudingts] [bit] NOT NULL ,
[if_fbxs] [bit] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[eta] WITH NOCHECK ADD
CONSTRAINT [DF_eta_ctgd0] DEFAULT (0) FOR [ctgd0],
CONSTRAINT [DF_eta_ctgd2] DEFAULT (0) FOR [ctgd2],
CONSTRAINT [DF_eta_lastctgd] DEFAULT (0) FOR [lastctgd],
CONSTRAINT [DF_eta_currctgd] DEFAULT (0) FOR [currctgd],
CONSTRAINT [DF_eta_fbdd] DEFAULT (0) FOR [fbdd],
CONSTRAINT [DF_eta_guding] DEFAULT (0) FOR [guding],
CONSTRAINT [DF_eta_hn] DEFAULT (1) FOR [hn],
CONSTRAINT [DF_eta_dbslb] DEFAULT (0) FOR [dbslb],
CONSTRAINT [DF_eta_tslb] DEFAULT (0) FOR [tslb],
CONSTRAINT [DF_eta_xslb] DEFAULT (0) FOR [xslb],
CONSTRAINT [DF_eta_addje] DEFAULT (0) FOR [addje],
CONSTRAINT [DF_eta_tctgd] DEFAULT (0) FOR [tctgd],
CONSTRAINT [DF_eta_totalctgd] DEFAULT (0) FOR [totalctgd],
CONSTRAINT [DF_eta_djxs1] DEFAULT (0) FOR [djxs1],
CONSTRAINT [DF_eta_djxs2] DEFAULT (0) FOR [djxs2],
CONSTRAINT [DF_eta_djxs3] DEFAULT (0) FOR [djxs3],
CONSTRAINT [DF_eta_djxs4] DEFAULT (0) FOR [djxs4],
CONSTRAINT [DF_eta_fld1] DEFAULT (0) FOR [fld1],
CONSTRAINT [DF_eta_fld2] DEFAULT (0) FOR [fld2],
CONSTRAINT [DF_eta_fld3] DEFAULT (0) FOR [fld3],
CONSTRAINT [DF_eta_fld4] DEFAULT (0) FOR [fld4],
CONSTRAINT [DF_eta_if_fenlei] DEFAULT (0) FOR [if_fenlei],
CONSTRAINT [DF_eta_if_1] DEFAULT (0) FOR [if_1],
CONSTRAINT [DF_eta_if_blxs] DEFAULT (0) FOR [if_blxs],
CONSTRAINT [DF_eta_if_man] DEFAULT (0) FOR [if_man],
CONSTRAINT [DF_eta_if_cor] DEFAULT (0) FOR [if_cor],
CONSTRAINT [DF_eta_if_guding] DEFAULT (0) FOR [if_guding],
CONSTRAINT [DF_eta_if_other] DEFAULT (0) FOR [if_other],
CONSTRAINT [DF_eta_if_dy] DEFAULT (0) FOR [if_dy],
CONSTRAINT [DF_eta_if_del] DEFAULT (0) FOR [if_del],
CONSTRAINT [DF_eta_if_bys] DEFAULT (0) FOR [if_bys],
CONSTRAINT [DF_eta_if_xs1] DEFAULT (0) FOR [if_xs1],
CONSTRAINT [DF_eta_if_xs] DEFAULT (0) FOR [if_xs],
CONSTRAINT [DF_eta_if_dbs] DEFAULT (0) FOR [if_dbs],
CONSTRAINT [DF_eta_xs] DEFAULT (0) FOR [xs],
CONSTRAINT [DF_eta_if_cb] DEFAULT (0) FOR [if_cb],
CONSTRAINT [DF_eta_hbdl] DEFAULT (0) FOR [hbdl],
CONSTRAINT [DF_eta_typeiddj] DEFAULT (0) FOR [typeiddj],
CONSTRAINT [DF_eta_otheriddj] DEFAULT (0) FOR [otheriddj],
CONSTRAINT [DF_eta_ftdj1] DEFAULT (0) FOR [ftdj1],
CONSTRAINT [DF_eta_ftdj2] DEFAULT (0) FOR [ftdj2],
CONSTRAINT [DF_eta_ftdj3] DEFAULT (0) FOR [ftdj3],
CONSTRAINT [DF_eta_ftdj4] DEFAULT (0) FOR [ftdj4],
CONSTRAINT [DF_eta_gddj1] DEFAULT (0) FOR [gddj1],
CONSTRAINT [DF_eta_gddj2] DEFAULT (0) FOR [gddj2],
CONSTRAINT [DF_eta_gddj3] DEFAULT (0) FOR [gddj3],
CONSTRAINT [DF_eta_gddj4] DEFAULT (0) FOR [gddj4],
CONSTRAINT [DF_eta_if_zs] DEFAULT (1) FOR [if_zs],
CONSTRAINT [DF_eta_if_sub] DEFAULT (0) FOR [if_sub],
CONSTRAINT [DF_eta_et_cb] DEFAULT (1) FOR [et_cb],
CONSTRAINT [DF_eta_addtype] DEFAULT (0) FOR [addtype],
CONSTRAINT [DF_eta_cortype] DEFAULT (0) FOR [cortype],
CONSTRAINT [DF_eta_if_nypg] DEFAULT (0) FOR [if_nypg],
CONSTRAINT [DF_eta_otherstr] DEFAULT ('#') FOR [jbstr],
CONSTRAINT [DF_eta_if_jb] DEFAULT (0) FOR [if_jb],
CONSTRAINT [DF_eta_if_gudingts] DEFAULT (0) FOR [if_gudingts],
CONSTRAINT [DF_eta_if_fbxs] DEFAULT (0) FOR [if_fbxs],
CONSTRAINT [eta_index1] UNIQUE NONCLUSTERED
(
[userid],
[et_id]
) ON [PRIMARY]
GO

and zjf.typeid=eta.typeid
and zjf.typeid=dprice.typeid
and eta.typeiddj=dprice.pdddf

用这样的条件试试
不知道是不是你想要的结果