Simon,
Thursday, June 27, 2002, 11:01:58 AM, you wrote:
SG> Sorry I should have made this a bit clear.
SG> I have to tables with users names in them.
SG> All I need is a list on the Usernames that are in one column but not the
SG> other.
SG> The problem is like Mr DuBois said, is that I get ever
On Thu, 27 Jun 2002 09:01:58 +0100
Simon Green <[EMAIL PROTECTED]> wrote:
> Sorry I should have made this a bit clear.
> I have to tables with users names in them.
> All I need is a list on the Usernames that are in one column but not the
> other.
> The problem is like Mr DuBois said, is that I
* Simon Green
> Sorry I should have made this a bit clear.
> I have to tables with users names in them.
> All I need is a list on the Usernames that are in one column but not the
> other.
SELECT table1.Username
FROM table1 LEFT JOIN table2 ON table1.Username = table2.Username
WHERE ISNULL(t
TECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 10:01 AM
Subject: Cartesian Product
> Sorry I should have made this a bit clear.
> I have to tables with users names in them.
> All I need is a list on the Usernames that are in one colum
are just not it one column?
Thanks
Simon
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: 27 June 2002 05:00
To: Simon Green; Mysql (E-mail)
Subject: Re: Cartesian Product
At 13:22 +0100 6/26/02, Simon Green wrote:
>Hi
>When I run my MySQL question I get what I
At 13:22 +0100 6/26/02, Simon Green wrote:
>Hi
>When I run my MySQL question I get what I think is a cartesian product?
>
>SELECT table1,Username
>FROM table1, table2
>WHERE table1.Username != table2.Username;
>
>If I just run'=' then no problem but it seems
Hi
When I run my MySQL question I get what I think is a cartesian product?
SELECT table1,Username
FROM table1, table2
WHERE table1.Username != table2.Username;
If I just run'=' then no problem but it seems to what to match every thing
with every thing
and so I run out of memory.
Is t
> Hi
> When I run my MySQL question I get what I think is a cartesian product?
>
> SELECT table1,Username
> FROM table1, table2
> WHERE table1.Username != table2.Username;
>
> If I just run'=' then no problem but it seems to what to match every thing
> wi
