> MySQL said: You have an error in your SQL syntax near 'EXISTS > > > Any tips? um, get a real database? sorry, couldn't resist ;o) mysql doesn't do subqueries hey, don't blame me use the outer join, testing for nulls rudy