'Distinct' SQL problem

[charter]

This works in Access2000..

SELECT DISTINCT News.NewsId, Upload.NewsID
FROM News INNER JOIN Upload ON News.NewsId=Upload.NewsID


But this doesn't work...

SELECT DISTINCT News.NewsId, Upload.NewsID, News.Section1
FROM News INNER JOIN Upload ON News.NewsId=Upload.NewsID


error message: News.Section1 is a memo field and Distinct cannot be used with this method.

Does anyone know of any work arounds? Need to get unique rows.


thanks
Mike

[MattR]

Well, the text is very, very long. You know you cannot do WHERE text = 'ADAD', you have to use 'like', remember? You cannot do DISTINCT textcol since it is too hard for a RDBMS to compare text columns.

Sorry, no can do. You could perhaps select the text column and ID into a temp table, then outer join to the main table where maintable.text LIKE 'othercol'

But that may not work. You'll probably have to do it in your application.