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
On Mon, 7 Feb 2005 19:22:15 +0100, Zouari Fourat <[EMAIL PROTECTED]> 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 u
:( 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 JO
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
Hello,
i made my own paginating class, it permit me to paginate over selected
data and let me do good presentation (page 1, page 2 ...)
i use adodb for db related functions, my application should show in
every page this set of informations :
Total results : Z, Total page : Y, You are on the page n
no one can help me outta here ?
On Mon, 21 Mar 2005 01:58:10 +0100, Zouari Fourat <[EMAIL PROTECTED]> wrote:
> Hello,
> i made my own paginating class, it permit me to paginate over selected
> data and let me do good presentation (page 1, page 2 ...)
> i use adodb for db rel
My apologies to all, i've mispelled that word, because in frensh we
say optimisation/optimiser ... there's no snoop dog's in zat :)
as about the subject, i think am no going to change my method and i'll
use ADOdb for some reasons (performance alse) :
*> my application should be db independan