>Hi,
>Here's a very simplified version of a view (named History):
SELECT Id, Date,
>FROM dbo.SCHeaders
>UNION
>Select Id, Date
>FROM dbo.Allocations
>UNION
>SELECT Id, Date
>FROM dbo.Detail
The view will always be used with a specific ID e.g :
>SELECT * FROM History WHERE ID='Fred'
>In this scenario there will always be only one record retrieved from the SCHeaders table.
>I need to exclude any records with a date that is earlier than that of the SCHeaders record from the result.
>FWIW this only need apply to the Detail table - there will be no such records in the Allocations table.
>
>A Sproc could be used if it is preferable....
>TIA
Do an inner join and include the date condition in the Where clause?