Get 3-table data without Inner-Join

select AdvertisementMst.*,AdPosition.PageId,AdPosition.Position,PageMaser.PageName
from AdvertisementMst,AdPosition,PageMaser
where AdvertisementMst.AdPositionId=AdPosition.AdPositionId and
AdvertisementMst.AdvertisementMstId=@AdvertisementMstId