You write two select statements. Or if the tables are related in someway (they hold information about someone some stuff in one table and other stuff in the other) then you do a select from both tables using an Inner Join.