[Q] SQL question

Is there a way for me to get a select statement to bring fields from two tables by a common select criteria? e.g Select lname, fname, status from contractors, visitors where status ="IN" I know this does not work. It gives me a cartesian product. I have been exploring different methods but I don't get the required result. The two tables have the same for the columns, and the criteria, which is STATUS ="IN" is common to both. I just want to combine the info from the two tables so that I can report it. Can I make a TEMP table, should I insert rows and populate the temp table? Can I load one table into another? Any help would be appreciated, thanks in advance. -- Saqib Mausoof -------------------------------------------------------------------- I have a hard enough time speaking for myself, so speaking on behalf of my employer is out of the question.