Sorry, but your question is not clear still.
Have a look at example:
DECLARE @Appointment TABLE (AID INT IDENTITY(1,1), [Date] DATETIME)
INSERT INTO @Appointment ([Date])
VALUES ('2013-01-01'), ('2014-01-02')
DECLARE @FoodLsit TABLE (FoodAptID INT IDENTITY(1,1), AID INT, FoodID INT, QTY INT)
INSERT INTO @FoodLsit (AID, FoodID, QTY)
VALUES(1, 1, 1), (1, 2, 2)
DECLARE @AlternateFoodList TABLE (FoodAlternateID INT IDENTITY(1,1), FoodAptID INT, FoodID INT, QTY INT)
INSERT INTO @AlternateFoodList (FoodAptID, FoodID, QTY)
VALUES(1, 3, 1), (1, 5, 2)
SELECT AFL.FoodAlternateID , FL.FoodAptID, AFL.FoodID, FL.QTY , A.AID, A.Date
FROM @AlternateFoodList AS AFL INNER JOIN @FoodLsit AS FL ON AFL.FoodAptID = FL.FoodAptID INNER JOIN @Appointment AS A ON FL.AID = A.AID
WHERE A.Date = '2013-01-01'
For further information about JOIN's, please see:
Visual Representation of SQL Joins[
^]