From: Neil Tompkins
Date: November 22 2012 2:30pm
Subject: Basic SELECT help
List-Archive: http://lists.mysql.com/mysql/228681
Message-Id: <CADa_cYqreG1JBu5ZtivwszCtgd+vwBARZFBuDXJxUC31y48Rag@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=047d7b3436a2490a6604cf164e48

--047d7b3436a2490a6604cf164e48
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I'm struggling with what I think is a basic select but can't think how to
do it : My data is

id,type

1000,5
1001,5
1002,2
1001,2
1003,2
1005,2
1006,1

From this I what to get a distinct list of id where the type equals 2 and 5

Any ideas ?

Neil

--047d7b3436a2490a6604cf164e48--