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
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 think is a cartesian product?
> >
> >SELECT table1,U
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 to what to match every thing
>with ever
