cset3300-module-2c

Qualify columns with the table name

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: | | 4 | 2 | Summer | 2010 | 2 | NE1350 | TR: 7:40 ­9:15 | | 5 | 4 | Fall | 2009 | 1 | NE1350 | MR: 4:00 ­5:15 | | 6 | 4 | Fall | 2010 | 1 | NE1350 | MR: 4:00 ­5:15 | | 7 | 3 | Spring | 2010 | 1 | NE1350 | TR: 12:30  ­ 1:45 | | 8 | 3 | FALL | 2010 | 1 | DL | DL | | 9 | 5 | Spring | 2010 | 1 | PL3150 | TR: 7:20  ­ 8:35 | | 10 | 5 | Spring | 2010 | 2 | DL | DL | | 11 | 5 | Summer | 2010 | 1 | DL | DL | | 12 | 5 | Fall | 2009 | 1 | NE1300 | TR: 9:45  ­ 11:00 | + ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­+ 12 rows in set (0.00 sec) 12 Example: Join SELECT * FROM courses,course_offerings WHERE courses.id = course_offerings.course_id AND courses.course_no LIKE “CSET%” 13 Example: Join SELECT * FROM courses,course_offerings WHERE courses.id = course_offerings.course_id AND courses.course_no LIKE “CSET%” mysql> SELECT * FROM courses,course_offerings WHERE courses.id = course_offerings.course_id AND courses.course_no LIKE "CSET%"; + ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­...
View Full Document

This document was uploaded on 02/25/2014 for the course CSET 3300 at Toledo.

Ask a homework question - tutors are online