Can someone help me with this statement

[kschuster]

My objective is to search the users table and the value duePaid where dueYear = 2002 IF AVAILABLE

I'm pretty sure this statment is close... but I get syntax errors

writing for Mysql

select u.userNameFirst, u.id, d.dueYear, d.duePaid
from users as u OUTER JOIN dues as d ON u.id=d.userid

WHERE

u.userNameLast like 's%'

and d.dueYear = '2002'

Thanks

[statrat]

what about this?

select u.userNameFirst, u.id, d.dueYear, d.duePaid
from users as u, dues as d
WHERE
u.id=d.userid
and u.userNameLast like 's%'
and d.dueYear = '2002'

[kschuster]

I actually figured iyt out. The statement is as follows:

SELECT * FROM users
LEFT OUTER JOIN dues ON users.id = dues.userid AND dues.dueYear='2003'

WHERE userNameLast like 's%' AND userType='Member';

Right out of the MySql ref. guide - doh