We help IT Professionals succeed at work.

Query Optimization (trees) trees against SQL expression

evry2004
evry2004 asked
on
Medium Priority
527 Views
Last Modified: 2012-05-06
Both these trees represent the same SQL query posed against the Student and Course database tables can you try to  Produce the SQL expression.


clip-image002.jpg
tables.png
Comment
Watch Question

SharathData Engineer
CERTIFIED EXPERT

Commented:
What is your expected result?

Author

Commented:
SELECT DISTINCT Student-name FROM Student-no, Student, StudentGradeWHERE C.Credit-point= 3
AND S.Student-no = SG.Student-no
AND C.Course-no = SG.Course-no;
Data Engineer
CERTIFIED EXPERT
Commented:
Are you looking for this?

SELECT DISTINCT S.[Student-Name]
  FROM Student S
  JOIN StudentGrade SG ON S.[Student-No] = SG.[Student-No]
  JOIN Course C ON SG.[Course-No] = C.[Course-No]
 WHERE C.[VCredit-Point] = 3

Open in new window

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.