var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL subquery memo field error
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?