select distinct Package.id as PackID, InSheet.id as InSheetID, OutSheet.id as OutSheetID
from Package left outer join
InSheet on Package.InSheetID=InSheet.id left outer join
OutSheet on Package.OutSheetID=OutSheet.id
create view test
as
select * from Package as a inner join InSheet as b a.InSheetID=b.InSheetID inner join OutSheet c on a.OutSheetID=c.OutSheetID
where (select * from Client as d inner join InSheet as b d.ID=b.ClientID inner join OutSheet c on d.ID=c.ClientID )
select
*
from
Package a
join
InSheet b on a.InSheetID=b.ClientID
join
OutSheet c on a.OutSheetID=c.ClientID
[/Quote]
就是要建一个View
它的InClientID来自于Client的id
它的OutClientID也来自于Client的id