Consulting

Results 1 to 6 of 6

Thread: SQL help, ms access

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-31-2010, 07:53 AM #1
    lienlee
    lienlee is offline
    VBAX Regular
    Joined
    May 2010
    Posts
    77

    SQL help, ms access

    SELECT count (distinct Subject_Area.Subject_Area_Name) as "number", Subject_Domain.Subject_Domain_Name
    FROM Data_Model, (Subject_Domain INNER JOIN Subject_Area ON Subject_Domain.Subject_Domain_ID = Subject_Area.Subject_Domain_ID) INNER JOIN Conceptual_Entity ON Subject_Area.Subject_Area_ID = Conceptual_Entity.Subject_Area_ID


    it keeps saying i have a syntax error(missing operator) in query expression 'count(distinct subject_area.subject_Area_name)
    im trying to count each distinct subject area name for each subject domain name
    Last edited by lienlee; 05-31-2010 at 10:53 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules