From: Michael Dykman Date: November 22 2012 3:06pm Subject: Re: Basic SELECT help List-Archive: http://lists.mysql.com/mysql/228689 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=f46d043c7b1486192d04cf16d0ff --f46d043c7b1486192d04cf16d0ff Content-Type: text/plain; charset=ISO-8859-1 Keep joining I think. In the absence of intersect (which incurs the cost of a query per type anyhow ), this join pattern is the only option I can think of. On 2012-11-22 10:01 AM, "Neil Tompkins" wrote: Michael, Thanks this kind of works if I'm checking two types. But what about if I have 5 types ? On Thu, Nov 22, 2012 at 2:53 PM, Michael Dykman wrote: > > > > response did not go to the list.. > > > > > > I assume that you mean the id must be associated with bo... > > > > > > > -- > > - michael dykman > > - mdykman@stripped > > > > May the Source be with you. > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe... > --f46d043c7b1486192d04cf16d0ff--