I have a table that looks like this:
DATA
ID (pk)
KeywordID
Rank
Date
URL
Can I use one select statement to pull a resultset that looks like this:
ID | KeywordID | Rank1 | Rank2 | URL
Where Rank1 would be based on one condition and Rank2 would be based on a different condition. I was hoping I could use a query similar to this, but apparently not.
SELECT ID, KeywordID, Rank,
(SELECT Rank FROM RankingData
WHERE DateStamp = '1/19/2006') AS Expr1
FROM RankingData
WHERE (DateStamp = '1/18/2006')
Can this be done?