Return Empty Result

[june_c21]

hi, why when i wrote

 

SELECT user.acc_no, report1.staff_no, user.name FROM user,report1 WHERE report1.staff_no = user.staff_no && user.bank ='Maybank' group by staff_no

 

it return zero result.

 

if i write the querry without user.bank ='Maybank'

 

it return the result.

 

What happen?

[Chris92]

Because there are no rows where the feilds report1.staff_no=user.staff.no and the user.bank=Mybank. But there are rows where the field report1.staff_no=user.staff_no.

[june_c21]

sorry, my english is poor and i can't get what you means. can you explain more details.

[Chris92]

Ok, Your query is probobally able to find rows where the feild

`report1.staff_no` = 'user.staff_no'

but it cannot find any rows where the two feilds

`report1.staff_no`='user.staff_no' AND `user.bank`='Maybank'

 

Maybe your &&'s should be replaced with AND:

mysql_query("SELECT `user.acc_no`, `report1.staff_no`, `user.name` FROM user,report1 WHERE `report1.staff_no` = 'user.staff_no' AND `user.bank` ='Maybank' GROUP BY `staff_no`");

[june_c21]

i try to put AND but still return empty result.

 

there is data and rows for these

`report1.staff_no`='user.staff_no' AND `user.bank`='Maybank'

 

if i put

select * from user where user.bank='maybank' also return empty result.

[Barand]

Run this query

 

SELECT user.acc_no, report1.staff_no, user.name, user.bank 
FROM user, report1 
WHERE report1.staff_no = user.staff_no

 

Do any of the results have Maybank in the user.bank column?

[june_c21]

barand, yes. got maybank in that column

[Chris92]

Don't forget about case sensativity, maybe you meant to do user.bank`='maybank'

[june_c21]

i try to put 'MAYBANK' or 'Maybank' or 'maybank'. still return empty result

[june_c21]

Run this query

 

SELECT user.acc_no, report1.staff_no, user.name, user.bank 
FROM user, report1 
WHERE report1.staff_no = user.staff_no

 

Do any of the results have Maybank in the user.bank column?

 

 

if i put

SELECT user.acc_no, report1.staff_no, user.name, user.bank

FROM user, report1

WHERE report1.staff_no = user.staff_no and bank='MAYBANK'

 

it return empty result

[Barand]

Note that 'maybank' will not match 'maybank  '

 

try

SELECT user.acc_no, report1.staff_no, user.name, user.bank
FROM user, report1
WHERE report1.staff_no = user.staff_no and user.bank LIKE '%MAYBANK%'

[june_c21]

thanks a lot.

 

-SOLVED-