t; reserved words, which might be a good suggestion to the
> original poster.
>
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
>
>
> - Original Message -
> From: "gerald_clark" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
&g
clark" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, 28 May, 2003 16:49
Subject: Re: problem with subquery
WHERE TAB2_ID 2
is the problem.
Do you want = or <> or what?
Also your version of MySQL must support sub selects.
James Moe wrote:
>-BEGIN PGP
WHERE TAB2_ID 2
is the problem.
Do you want = or <> or what?
Also your version of MySQL must support sub selects.
James Moe wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 May 2003 15:18:16 -0400, Hassan Farha wrote:
SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID FROM TAB2
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 May 2003 15:18:16 -0400, Hassan Farha wrote:
>SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID FROM TAB2 WHERE TAB2_ID
>> 2)
>
>I know I this select is very simple, ...
So what's the problem?
- --
jimoe at sohnen-moe dot com
pgp/gpg
I am trying to do what seems like a simple Select:
SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID FROM TAB2 WHERE TAB2_ID
> 2)
I know I this select is very simple, but I need to make this one work before
I can tackle my 'real' query where the subquery is essential.
I have MySQL version 4.1.
