Bug #34625 MYSQL returns empty resutl

• Submitted: 17 Feb 2008 11:46
• Modified: 17 Feb 2008 14:35
• Reporter: june chong
• Status: Not a Bug
• Category: MySQL Query Browser
• Severity: S1 (Critical)
• OS: Linux
• CPU Architecture: Any
• Tags: MYSQL returns empty resutl

[17 Feb 2008 11:46] june chong

Description:
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? 

How to repeat:
MYSQL returns empty resutl

[17 Feb 2008 14:35] Valeriy Kravchuk

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. Likely your table just does NOT contain rows where user.bank ='Maybank'...

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.