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: luc_foisy@stripped
>
><<<<< 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 <mysql-thread117549@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
