I need to extract unique rows from two tables joined together.

SELECT DISTINCT News.NewsID, News.Title, Upload.NewsID, Upload.Filename
FROM News LEFT JOIN Upload ON News.NewsID=Upload.NewsID
ORDER BY News.NewsID DESC

I need to compare the NewsID in each table and then output the News.Title with Upload.Filename

..But unfortunately Access2000 does not support a DISTINCT query that compares memo fields (News.Title).


Can anyone please post an example of either:

1. How to make the above SQL work

2. Give an example of how to use 2 queries instead of a join to get the same result?


All help greatly appreciated
Charter