What is up with my query? Please help!

[southbeach]

I have a query command

SELECT a . * , b . * FROM potable a, uctable b WHERE b.UsrID = 1 AND a.poCstID = b.ucCstID AND `poBranch` = 'MIA' ORDER BY poID LIMIT 0, 20

In this particular case poCstID = 3 and so does ucCstID. Fields are defined as int(9) in both tables.

I am getting an empty query. If I change the query to

SELECT a . * , b . * FROM potable a, uctable b WHERE b.UsrID = 1 AND a.poCstID = 3 AND `poBranch` = 'MIA' ORDER BY poID LIMIT 0, 20

--> NOTICE I simply a number 3 in lieu of b.ucCstID

I get the expected results ... What is up with that?

Your assistance will be truly appreciated.

 

[r937]

dump the rows that you think are involved from each table and let's have a look at the data

you've shown us two queries and asked why they return what they return

the answer is: because that's what's in the tables



r937.com | rudy.ca

 

[southbeach]

r937,

After walking away for a couple of hours and taking a second look, I confirmed what you stated, "because that is what the table has ...".

I totally missed the fact that one of the table did not have matching record - I had the wrong DB opened on one of the pages I flipped in/out of ...

Thanks,

 

[r937]

it's nice when one of my guesses turns out right...

thanks for the update



r937.com | rudy.ca