SQL problem, what am I doing wong? 
Author Message
 SQL problem, what am I doing wong?

Can you post the table definitions?
Are there NULLs in the columns you're comparing?

--
Kalen Delaney
MCSE, SQL Server MCT, MVP
www.InsideSQLServer.com
Feed Someone for Free Today:
     www.TheHungerSite.com


Quote:
> I'm not sure it should make a difference, since we're doing a NOT
operation.
> In any case, rewrote that particular value, didn't make a difference :-(



> > David,
> >     Check the space between dave and ross.That only seems the problem.

> > Thanx,
> > DineshTK



Thu, 05 Dec 2002 03:00:00 GMT
 SQL problem, what am I doing wong?

Hi,
I'm trying to find a person who is one table and not other. Below is the
query I thought would do it plus 2 troubleshooting queries and the output.
Why doesn't the first query work?

/******************/
/*        Query           */
/******************/
select subscribername from billingdetails
where subscribername
not in (select subscribername from customercredits)

select subscribername from customercredits where subscribername='dave ross'

select subscribername from billingdetails where subscribername='dave ross'
/*******************/

/**************/
/       output        /
/**************/

subscribername
--------------------------------------------------

(0 row(s) affected)

subscribername
--------------------------------------------------

(0 row(s) affected)

subscribername
--------------------------------------------------
Dave Ross

(1 row(s) affected)



Fri, 06 Dec 2002 03:00:00 GMT
 SQL problem, what am I doing wong?
David,
    Check the space between dave and ross.That only seems the problem.

Thanx,
DineshTK



Fri, 06 Dec 2002 03:00:00 GMT
 SQL problem, what am I doing wong?
I'm not sure it should make a difference, since we're doing a NOT operation.
In any case, rewrote that particular value, didn't make a difference :-(


Quote:
> David,
>     Check the space between dave and ross.That only seems the problem.

> Thanx,
> DineshTK



Fri, 06 Dec 2002 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Parameter Problem - What am I doing wrong?

2. Another date problem - What am I doing wrong?

3. Update Problem, What am I doing wrong?

4. ADO and SQL: what am I doing wrong ?

5. SQL What am I doing wrong ?

6. What am I doing wrong (RTRIM, PL/SQL)

7. What am I forgetting or doing wrong

8. Am I doing this the best way?

9. what am I doing wrong in this procedure?

10. TSQL question - what am I doing wrong?

11. what am i doing wrong?

12. Am I doing this correctly?


 
Powered by phpBB® Forum Software