I have a table that looks like this:
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.
Can this be done?Code:SELECT ID, KeywordID, Rank, (SELECT Rank FROM RankingData WHERE DateStamp = '1/19/2006') AS Expr1 FROM RankingData WHERE (DateStamp = '1/18/2006')