Kim -
From your description, it sounds like you're trying to do a query on tables that are not related. In order to have records in your return set, the records in the individual tables have to relate to one another somehow. If there is no relation, there will be no records returned (unless you specifically want a cartesean product, which is generally a no-no). You *might* be able to get what you want with a Union. Can you give us info on what your table structures are like?