Re: Select questions

2005-12-05 Thread Rhino
- 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

Re: Select questions

2005-12-05 Thread Rhino
; <[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

RE: Select questions

2005-12-05 Thread SGreen
"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

RE: Select questions

2005-12-05 Thread Kevin Fricke
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

Re: Select questions

2005-12-05 Thread Michael Stassen
[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

RE: Select questions

2005-12-05 Thread SGreen
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

RE: Select questions

2005-12-05 Thread Kevin Fricke
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

Re: Select questions

2005-12-05 Thread Rhino
: <[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

Re: Select questions

2005-12-05 Thread Rhino
- 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, fo

Re: Select questions

2005-12-05 Thread Michael Stassen
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

Select questions

2005-12-05 Thread Kevin Fricke
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 will pull all of these

Re: Easy (?) SELECT questions

2003-11-20 Thread Egor Egorov
[EMAIL PROTECTED] wrote: >> Mark Wilson <[EMAIL PROTECTED]> wrote: >>> Two related questions. >>> 1. I have a table with a "date" field. (Ex: '04/13/2002'). I want to get >>> a list >>> of all UNIQUE values for that field (many entries from the same day), >>> i.e., all >>> days with entries. >>> **

Re: Easy (?) SELECT questions

2003-11-19 Thread cpuworks
> Mark Wilson <[EMAIL PROTECTED]> wrote: >> Two related questions. >> 1. I have a table with a "date" field. (Ex: '04/13/2002'). I want to get >> a list >> of all UNIQUE values for that field (many entries from the same day), >> i.e., all >> days with entries. >> ***

Re: Easy (?) SELECT questions

2003-11-19 Thread Egor Egorov
Mark Wilson <[EMAIL PROTECTED]> wrote: > Two related questions. > 1. I have a table with a "date" field. (Ex: '04/13/2002'). I want to get a list > of all UNIQUE values for that field (many entries from the same day), i.e., all > days with entries. > ** > CREAT

Easy (?) SELECT questions

2003-11-18 Thread Mark Wilson
Two related questions. 1. I have a table with a "date" field. (Ex: '04/13/2002'). I want to get a list of all UNIQUE values for that field (many entries from the same day), i.e., all days with entries. ** CREATE TABLE metrics_events_power { mep_id int(11) NOT