Select questions

[Kevin Fricke]

Hello all....new to the list...having a bit of an issue here.

I have a reservations table that is linked to three separate tables, food,
packages and options.  A reservation can have multiple food options,
packages and options attached to it.

I am trying to run a query that will pull all of these out in the query
without all of the duplicate records.  Is this possible?  Can I pull a
select list into one query result field.

For example a reservation may look like this:

Reservation ID: 1
Client Name: Kevin

Food
----------
Nachos
Tacos
Ice Cream

Packages
----------
Live Music
Casino

Options
----------
Margarita Machine
Bartender



Do I have to run three queries to get the food, packages and options?  I was
hoping that this could be consolidated into one query.


Thanks for the help!!

Kevin