SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Mar 2002
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Charter

  2. #2
    \m/ R.I.P. Dimebag! \m/ JimBolla's Avatar
    Join Date
    Dec 2001
    Location
    erie, pa
    Posts
    1,130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    what is the longest length of data in the title field? if its not too large, the simplest solution would be to convert it to a Text.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •