#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    1
    Rep Power
    0

    Help with a query


    im supposed to Show the names of all artists which have at least one female member each. Use one or more subqueries. Do not use any joins. heres a link to the database diagram
    calstatela.edu/faculty/jhurley2/classes/cs122/

    im having a real hard time with these subqueries , so far what i have pretty much just finds the artists that have female members.


    select artistname from artists where artistid in (select artistid from xrefartistsmembers where memberid in (select memberid from members where gender="f"));
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2012
    Posts
    90
    Rep Power
    3
    sorry, what is the difference between "artists that have female members" and "all artists which have at least one female member each"? those sound like the same thing.

IMN logo majestic logo threadwatch logo seochat tools logo