I could use some help with a problem I've been struggling with at work.

I try to do queries in one shot, without building views.

I have a standard query, and want to enclose a subquery select to only pull 1 (top record), but get errors because it's a memo field. Apparently SQL doesn't like that. My query is something like:

Select * from A
(select top 1 memofield from B where A.1 = B.1)
Where A.2 = 2000

I don't recall the exact query -- nothing close to what I typed -- but it would work if the memofield were just a number or simple character. Can anyone advise me on this?