--这样试一下!
select a.meetcontent,a.notename,b.filename,b.addr
from Tb_Meeting_primary a left join Tb_Sys_Adjunct b
on a.id=b.id -- Tb_Meeting_primary 与 Tb_Sys_Adjunct 的连接条件
where a.meetid=@meetid and (b.tablename='tb_filetable' and b.webth=@meetid )
select a.meetcontent,a.notename,b.filename,b.addr
from Tb_Meeting_primary a left join Tb_Sys_Adjunct b
on a.id=b.id -- Tb_Meeting_primary 与 Tb_Sys_Adjunct 的连接条件
where a.meetid=@meetid and (b.tablename='tb_filetable' and b.webth=@meetid )
where a.meetid=@meetid and (b.tablename='tb_filetable' and b.webth=@meetid )
这个条件的话就说明必须是3个条件全满足才可以查到数据否则就算a里有数据b里没有数据的话就连a 里的数据也查不出来了!!还望不吝赐教!!!
-------------
把a.meetid=@meetid去掉就行了
from Tb_Meeting_primarynote a left join Tb_Sys_Adjunct b on b.WithTBID=a.MeetId
where b.WithTB='Tb_Meeting_primarynote' and b.WithTBID=@meetid
这样还是不能保证b里无数据时也要查出a里的数据!! 是不不应该用where形式的条件啊?占用您一点时间,大侠们谢谢啦!
select a.MeetId,a.Mobject,a.notecontent, b.TrueName,b.AdjunctAddress
from Tb_Meeting_primarynote a left join Tb_Sys_Adjunct b on b.WithTBID=a.MeetId
where a.meetid=@meetid and b.WithTB='Tb_Meeting_primarynote'
select a.MeetId,a.Mobject,a.notecontent, b.TrueName,b.AdjunctAddress
from Tb_Meeting_primarynote a left join Tb_Sys_Adjunct b on b.WithTBID=a.MeetId
and b.WithTB='Tb_Meeting_primarynote'
where a.meetid=@meetid