February 11, 2013 at 9:28 am
pls ignore.. wrong server grp
February 11, 2013 at 9:32 am
You need to alias the Inner select
Eg
select count (*)
from
(SELECT top 100 percent Form.FormName, Markets.MarketName
FROM Form INNER JOIN
FormMarkets_Link ON Form.FormID = FormMarkets_Link.ptFormID INNER JOIN
Markets ON FormMarkets_Link.ptMarketID = Markets.MarketID CROSS JOIN
FormStatus
WHERE (FormStatus.FormStatusID = 3)
) AliasMe
_________________________________________________________________________
SSC Guide to Posting and Best Practices
February 11, 2013 at 11:35 am
I cannot tell you how many times I've been busted for forgetting to alias things. 😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply