How do you have data from 2 sql statements

How do I have two sql statements within one asp file. I have been only using one and now I need to get data from another table to compare.