Posted by Brian Wotherspoon on 02/15/06 14:41

I have a table with data that is refreshed regularly but I still need to
store the old data. I have created a seperate table with a foreign key
to the table and the date on which it was replaced. I'm looking for an
efficient way to select only the active data.

Currently I use:

SELECT ...
FROM DataTable AS D
LEFT OUTER JOIN InactiveTable AS I ON I.Key = D.Key
WHERE D.Key IS NULL

However I am not convinced that this is the most efficient, or the most
intuitive method of acheiving this.

Can anyone suggest a more efficient way of getting this information
please.

Many thanks.


*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: very slow query (select count(*) from table)
• Prev in forum: Re: Client Web Browser & Remote SQL Script Error?
• Thread view: More efficient than LEFT JOIN

[Reply to this message]