Error. PLease Help. Urgent!

[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?

[jvrothjr]

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

 

 

[aschk]

I don't believe your statement (jvrothjr) is any different to june's original post.

Explain (in WORDS) what you want, and give a sample expected result, and also the layout of your current tables. Without this information it's rather difficult to ascertain what you want.

 

Also specify your JOIN on's in the JOIN clause NOT in the WHERE clause.

SELECT u.acc_no
      , r.staff_no
      , u.name 
FROM user u
JOIN report1 r ON r.staff_no = u.staff_no 
WHERE u.bank ='Maybank' 
GROUP BY staff_no 

 

Give us the information I asked for and we will progress this for you.