- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; ; "'Rhino'"
<[EMAIL PROTECTED]>
Sent: Monday, December 05, 2005 10:01 PM
Subject: Re: Select questions
[EMAIL P
; <[EMAIL PROTECTED]>
To: "'Rhino'" <[EMAIL PROTECTED]>
Sent: Monday, December 05, 2005 9:47 PM
Subject: RE: Select questions
Forgot to include the query.
select r.id, r.reservation_date, f.name as food_name, p.name as
package_name, e.name as extra_name
from res
"Kevin Fricke" <[EMAIL PROTECTED]> wrote on 12/05/2005 10:05:36 PM:
> I am simply trying to build an exportable report of the results. For
> example, I need to run a monthly report that will pull all of the
> reservations with food, packages and extras.
>
> I suppose that the only way to do this
three results?
Kevin
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Monday, December 05, 2005 9:01 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com; 'Rhino'
Subject: Re: Select questions
[EMAIL PROTECTED] wrote:
> Thank you
[EMAIL PROTECTED] wrote:
Thank you for the table structures (I prefer the output from SHOW CREATE
TABLE..) Now, would you mind also posting the actual query you used to
produce what you are calling "duplicated" results?
Thanks!
Shawn Green
Database Administrator
Unimin Corporation - Spruc
ist
> Chips and Salsa
> 425 1/27/2006 0:00 Fajitas Danny Santos Server
> 425 1/27/2006 0:00 Continental Tray Beth Williams Server
> 425 1/27/2006 0:00 Traditional Sandwich Tray Caricaturist
> Server
> 425 1/27/2006 0:00 Fajitas Danny Santos Margarita Machine
garita Machines
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Monday, December 05, 2005 5:19 PM
To: mysql; [EMAIL PROTECTED]
Subject: Re: Select questions
I'm copying the list on this reply so that everyone can benefit from the
discussion
Thanks for clarifying that you und
: <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Sent: Monday, December 05, 2005 5:58 PM
Subject: Re: Select questions
I understand joins. However, when I join the three tables, it will contain
duplicate reservation id's. If a reservation has three food options, th
- Original Message -
From: "Kevin Fricke" <[EMAIL PROTECTED]>
To:
Sent: Monday, December 05, 2005 3:14 PM
Subject: Select questions
Hello allnew 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
Kevin Fricke wrote:
Hello allnew 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
10 matches
Mail list logo
