Zouari Fourat wrote:
am using mysql 3 so i can't do that subquery, how can we do that in mysql 3 ?
and neither can anyone else ;-)... rather a pain, but mysql.com have been
kind enough
to give a detailed explaination on how to rewrite subselect queries as join
queries:
If you put your brain in ge
am using mysql 3 so i can't do that subquery, how can we do that in mysql 3 ?
On Mon, 7 Feb 2005 19:47:08 +, Simon Rees
<[EMAIL PROTECTED]> wrote:
> On Monday 07 February 2005 18:22, Zouari Fourat wrote:
> > Hello
> > I have 2 tables with two columns in each one (cloned tables) like this :
>
On Monday 07 February 2005 18:22, Zouari Fourat wrote:
> Hello
> I have 2 tables with two columns in each one (cloned tables) like this :
>
> ID int(6)
> UserName varchar(25)
>
> and i would like to select usernames from table1 that doesnt appear in
> table2 so i did this :
Depending on which data
:( nothing
On Mon, 7 Feb 2005 14:10:10 -0500, Joseph Crawford <[EMAIL PROTECTED]> wrote:
> try INNER JOIN?
>
>
> On Mon, 7 Feb 2005 19:47:29 +0100, Zouari Fourat <[EMAIL PROTECTED]> wrote:
> > that wont work :(
> > and either when changing RIGHT to LEFT JOIN that wont work
> >
> >
> > On Mon, 7
that wont work :(
and either when changing RIGHT to LEFT JOIN that wont work
On Mon, 7 Feb 2005 13:41:01 -0500, Joseph Crawford <[EMAIL PROTECTED]> wrote:
> try doing this
>
> SELECT a.UserName FROM table1 a RIGHT OUTER JOIN table2 b ON
> (a.UserName != b.username)
>
> On Mon, 7 Feb 2005 19:22:
Hello
I have 2 tables with two columns in each one (cloned tables) like this :
ID int(6)
UserName varchar(25)
and i would like to select usernames from table1 that doesnt appear in table2
so i did this :
SELECT a.UserName FROM table1 a RIGHT OUTER JOIN table2 b ON
(a.UserName = b.username)
and