SQL error

hi, can someone help me to identify what's wrong with this line of code? it return zero result.

SELECT id, month, start_date, end_date, user.name, report.staff_no,details,amount,gl_code,user.bank,user.acc_no,status FROM user,report WHERE report.staff_no = user.staff_no

 

use uniform referencing in your sql for all the fields you pull out, like table.field
if you get no results, then no records exist in your table.

 

You can also try this sql validator to help you trouble shoot your statments. It has worked great for me as my sql statments have become more complex.

http://developer.mimer.com/validator/parser200x/index.tml

 

june_c21 - What database are you using?

Are the fields staff_no in the two tables report and user of same
type and size?