What have you tried?
What did you get?
Why is it not what you expected?

Luc Foisy wrote:

>Some ficticious data
>
>ID     Data1   Data2   Data3
>1      1       141     1
>2      5       140     1
>3      4       142     1
>4      3       141     1
>5      2       142     1
>6      5       142     1
>7      7       140     1
>8      2       143     1
>9      3       142     1
>10     3       143     1
>11     4       144     1
>12     2       144     1
>13     8       141     2
>14     9       140     2
>15     6       142     2
>16     11      141     2
>17     0       142     2
>18     9       142     2
>19     10      140     2
>20     0       143     2
>21     11      142     2
>22     3       143     2
>23     6       144     2
>24     0       144     2
>
>For my return I only want a single instance of "Data1", so it will most likely need 
>be GROUP BY Data1
>
>I would like those records to include the "group" that does not contain a "Data2" 
>value of 141
>
>There is also a WHERE clause on "Data3" = 1
>
>The return would include these values for Data1
>
>7
>5
>2
>4
>
>Is there some way to do this with a single query?
>
>If this is unclear, let me know
>
>Luc Foisy 
>
>Technical Magic - www.technical-magic.com 
>1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 
>Phone: (613) 721-8850 Fax: (613) 596-5096 
>E-Mail: [EMAIL PROTECTED] 
>
><<<<< Fulfilling the Promise of Technology >>>>>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to