If your table structure is like this:
ID cat_id ball_id
1100 1 1
ball_id ball_name
1 Ball 1
cat_id cat_name
1 Cat 1
Then your query should be like:
SELECT B.ball_name,C.cat_name FROM apple A
INNER JOIN ball B ON A.ball_id = B.ball_id
INNER JOIN cat C ON A.cat_id = C.cat_id
WHERE A.ID = 1100
Please refer:
MSDN : Join Fundamentals[
^]
MSDN : Join Hints (Transact-SQL)[
^]
--Amit