june_c21 Posted February 17, 2008 Share Posted February 17, 2008 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? Quote Link to comment Share on other sites More sharing options...
Chris92 Posted February 17, 2008 Share Posted February 17, 2008 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. Quote Link to comment Share on other sites More sharing options...
june_c21 Posted February 17, 2008 Author Share Posted February 17, 2008 sorry, my english is poor and i can't get what you means. can you explain more details. Quote Link to comment Share on other sites More sharing options...
Chris92 Posted February 17, 2008 Share Posted February 17, 2008 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`"); Quote Link to comment Share on other sites More sharing options...
june_c21 Posted February 17, 2008 Author Share Posted February 17, 2008 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. Quote Link to comment Share on other sites More sharing options...
Barand Posted February 17, 2008 Share Posted February 17, 2008 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? Quote Link to comment Share on other sites More sharing options...
june_c21 Posted February 17, 2008 Author Share Posted February 17, 2008 barand, yes. got maybank in that column Quote Link to comment Share on other sites More sharing options...
Chris92 Posted February 17, 2008 Share Posted February 17, 2008 Don't forget about case sensativity, maybe you meant to do user.bank`='maybank' Quote Link to comment Share on other sites More sharing options...
june_c21 Posted February 17, 2008 Author Share Posted February 17, 2008 i try to put 'MAYBANK' or 'Maybank' or 'maybank'. still return empty result Quote Link to comment Share on other sites More sharing options...
june_c21 Posted February 17, 2008 Author Share Posted February 17, 2008 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 Quote Link to comment Share on other sites More sharing options...
Barand Posted February 17, 2008 Share Posted February 17, 2008 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%' Quote Link to comment Share on other sites More sharing options...
june_c21 Posted February 17, 2008 Author Share Posted February 17, 2008 thanks a lot. -SOLVED- Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.