I am not a SQL guru by any means so I hope you can help me out. I am not even certain this is the place to post this question. I have 2 tables, users and weeklypicks. users has: user_id username weeklypicks has: user_id week_id teamname My problem is this. I need to be able to show all users and their pick for a certain week, even if they have not made a pick for that week. In other words I want to be able to pick a weeknumber and only show the picks users have made for that week along with users that have not yet made a pick for that week. As users make their pick a record is created in the weeklypick table so users that have not yet made a pick will not have a record in that table for that week. I have gone around and around and just can't figure it out. Any help would be appreciated. Thanks.