Need logic for this Query?

sql, sql-server

Solution

Solution #1 -

SELECT e.*, a.AgeGroupName 
FROM dbo.tblEmploee e
JOIN dbo.tblAgeGroup a ON e.EmpAge BETWEEN a.AgeGroupMinAge AND a.AgeGroupMaxAge

Solution #2 -

SELECT *
FROM dbo.tblEmploee e
OUTER APPLY (
     SELECT TOP 1 a.AgeGroupName 
     FROM dbo.tblAgeGroup a
     WHERE e.EmpAge BETWEEN a.AgeGroupMinAge AND a.AgeGroupMaxAge 
) a

Solution #3 -

SELECT e.*, AgeGroupName = (
     SELECT a.AgeGroupName 
     FROM dbo.tblAgeGroup a
     WHERE e.EmpAge BETWEEN a.AgeGroupMinAge AND a.AgeGroupMaxAge
) 
FROM dbo.tblEmploee e

Problem

I am a beginner in Sql Please guide me. I have two tables 1) tblEmploee & 2) tblAgeGroup What is the best way to achieve the AgeGroupName to the tblEmploee table.

Original source