Page 1 of 2 12 LastLast
Results 1 to 15 of 26

Thread: sql inquiry

  1. #1
    Join Date
    Feb 2012
    Posts
    14

    Unanswered: sql inquiry

    any help would be greatly appreciated...thank you very much in advance!
    thanks for the help
    Last edited by Delylah; 02-17-12 at 15:52. Reason: Completed

  2. #2
    Join Date
    Feb 2012
    Posts
    14
    I only have the first two tackled, or what I believe is the answer to the first two.

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Delylah View Post
    ...so bare with me.
    bear with me = have patience

    bare with me = let's get undressed together




    I can show you what I have and you can tell me if I am close or not?
    yup, that's the only way you're gonna get any assistance on this site

    we ain't doing your homework for you
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Feb 2012
    Posts
    14
    Here is what I have, and please disregard the "bare" incident.



    It was an accident
    Last edited by Delylah; 02-17-12 at 15:51.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by Delylah View Post
    Here is what I have, and please disregard the "bare" incident.
    Not on your life...what a great idea...college pics for answers
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    It would help if you posted sample data, preferably in DML Form, and what the expected results for each query are suppose to be
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Feb 2012
    Posts
    14
    I beleive joining them would make it customized from what my professor said to me when I confronted her about it.

  8. #8
    Join Date
    Feb 2012
    Posts
    14
    Ok give me a few and i will gather info
    Last edited by Delylah; 02-17-12 at 15:52.

  9. #9
    Join Date
    Feb 2012
    Posts
    14
    I appreciatet your help...it makes sense too
    Last edited by Delylah; 02-17-12 at 16:00.

  10. #10
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Code:
    	SELECT s.Name 
      	  FROM Student		  s
    INNER JOIN Enrolled		  e
    	    ON s.StudNum	= e.StudNum
    	 WHERE Major		= 'CS'
    	   AND ClassId		= 'CIS111'
    As far as assignment 2...Which Professor? Or for which Students? Or for which Class
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  11. #11
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by Delylah View Post
    Want some upper shots for help?
    Top Shelf Shots?

    Louis XIII
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  12. #12
    Join Date
    Feb 2012
    Posts
    14
    Bret, I do not have any samlpe data. I only have the information provided to me...

  13. #13
    Join Date
    Feb 2012
    Posts
    14
    I will post the questions as they were given to me...see if that helps you out.

  14. #14
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    this is for all the Prof's and all of their Students

    What College is this for?

    Code:
    	SELECT DISTINCT f.Name, s.Name
    	  FROM Faculty f
      INNER JOIN Class c
    	     ON f.ProfId = c.ProfId
      INNER JOIN Enrolled e
      	     ON c.ClassId = e.ClassId
      INNER JOIN Staudent s
    	     ON e.StudNum = s.StudNum
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  15. #15
    Join Date
    Feb 2012
    Posts
    14
    Tennessee State University

Posting Permissions

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