> SELECT 'mens', score FROM soccer_mens > WHERE gameDate = yesterday" to get > UNION ALL > SELECT 'womens', score FROM soccer_womens > WHERE gameDate = yesterday" to get > UNION ALL > et cetera feh haste makes waste see them typos above? edit them oot you definitely want a union -- these tables should not be joined rudy