each table is actually much bigger than that, over 10,000 entries ... now i need to get all three table's info at once ... since there is no index associated with any of those (poorly designed ... not by me) i am forced to use the WHERE clause.