Multiple MySQL Tables --> HTML Tables

Hi all, I have a newbie question, I hope somebody can help me out. I have an HTML form (query.html) that has a drop down menu of all 50 states and 3 checkboxes of 3 years (1999, 2000 and 2001), I want users to be able to select one state and any year(s) they want (they can choose one or more years). I have a MySQL DB that has 3 tables, each table has data for one year (i.e. states99, states00 and states01). I want to be able to have the results.php script connect to the database, make a query from multiple tables and display it to an HTML table, for example: State | 1999 | 2000 | or State | 1999 | 2001 ---------------------- AL |23,010|12,567| . . . Thank you for your time. Mouncef