Distinct with memo fields?
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