Re: OT: MySQL syntax help

Página superior
Adjuntos:
Obtener este mensaje como un correo
+ (text/plain)
Eliminar este mensaje
Responder a este mensaje
Autor: Kevin
Fecha:  
A: PLUG-DISCUSS
Asunto: Re: OT: MySQL syntax help

On 5/16/06 9:48 AM, "Darrin Chandler" <> wrote:

> On Tue, May 16, 2006 at 09:43:40AM -0700, Kevin wrote:
>> I need a query to pull every row from Table2 where the "kernel" field
>> matches ANY row in Table1. Any ideas???
>
> See docs for EXISTS


PERFECT! Thanks Darrin! Something like this will work.

SELECT *
FROM Table2
WHERE EXISTS
  (select *
    from Table1
    where kernel = Kernel);


...Kevin


---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss