Jeanne Boyarsky wrote:That look close to being right. What error are you getting?
One issue I see is that "SELECT endDate" is ambigious. I think you mean ig.enddate there.
Good point, although that's not the error I'm seeing. The error I get is:
Incorrect syntax near 'i'
It doesn't seem that the alias is well-liked in that position.