试试这个:create table TARINVOICE(
fseq int, finvnum varchar(50), prjcode varchar(10), fopuser varchar(10))insert into TARINVOICE
select 1 ,'T-100400-SCM-20131101-1' ,'100400', 'david'
create table tuserproject(
fseq int,fsapprjt varchar(10), fuserid varchar(10), fmanager varchar(10)
)insert into tuserproject
select 1 ,'100400', 'david', 'tom' union all
select 2 ,'100400', 'carol', 'vivan'
go
select t.fseq, t.finvnum,t.prjcode, t.fopuser,tt.fmanager
from TARINVOICE t
inner join tuserproject tt
on t.fseq = tt.fseq
--and t.prjcode = tt.fsapprjt
--and t.fopuser = tt.fuserid
/*
fseq finvnum prjcode fopuser fmanager
1 T-100400-SCM-20131101-1 100400 david tom
*/
fseq int, finvnum varchar(50), prjcode varchar(10), fopuser varchar(10))insert into TARINVOICE
select 1 ,'T-100400-SCM-20131101-1' ,'100400', 'david'
create table tuserproject(
fseq int,fsapprjt varchar(10), fuserid varchar(10), fmanager varchar(10)
)insert into tuserproject
select 1 ,'100400', 'david', 'tom' union all
select 2 ,'100400', 'carol', 'vivan'
go
select t.fseq, t.finvnum,t.prjcode, t.fopuser,tt.fmanager
from TARINVOICE t
inner join tuserproject tt
on t.fseq = tt.fseq
--and t.prjcode = tt.fsapprjt
--and t.fopuser = tt.fuserid
/*
fseq finvnum prjcode fopuser fmanager
1 T-100400-SCM-20131101-1 100400 david tom
*/
from TARINVOICE t
inner join tuserproject tt
on --t.fseq = tt.fseq
t.prjcode = tt.fsapprjt
and t.fopuser = tt.fuserid
create table TARINVOICE(
fseq int, finvnum varchar(50), prjcode varchar(10), fopuser varchar(10))
insert into TARINVOICE
select 1 ,'T-100400-SCM-20131101-1' ,'100400', 'david'
create table tuserproject(
fseq int,fsapprjt varchar(10), fuserid varchar(10), fmanager varchar(10)
)
insert into tuserproject
select 1 ,'100400', 'david', 'tom' union all
select 2 ,'100400', 'carol', 'vivan'
go
create view view_1
as
select a.fseq,finvnum,prjcode,b.fmanager from tarinvoice a join
tuserproject b on a.fseq=b.fseq --如果数据多点,可以发现规律,适当添加条件即可
select * from view_1