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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]