outer joins for search