cset3300-module-2c

Ne1350 tr 740915 cset4100 serverside programming

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: 2 | NE1350 | TR: 7:40 ­9:15 | | 4 | CSET4100 | Server ­Side Programming | 4 | 5 | 4 | Fall | 2009 | 1 | NE1350 | MR: 4:00 ­5:15 | | 4 | CSET4100 | Server ­Side Programming | 4 | 6 | 4 | Fall | 2010 | 1 | NE1350 | MR: 4:00 ­5:15 | + ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­+ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­+ 8 rows in set (0.00 sec) 13 Example: JOIN contd. 14 Example: JOIN contd. • Want to only select a subset of columns 14 Example: JOIN contd. • Want to only select a subset of columns • Problem: what if both tables have an id and we only want one of them? 14 Example: JOIN contd. • Want to only select a subset of columns • Problem: what if both tables have an id and we only want one of them? • qualify columns with the table name: 14 Example: JOIN contd. • Want to only select a subset of columns • Problem: what if both tables have an id and we only want one of them? • qualify columns with the table name: • <table_name>.<column_name> 14 Example: JOIN contd. • Want to only select a subset of columns • Problem: what if both tables have an id and we only want one of them? • qualify columns with the table name: • <table_name>.<column_name> SELECT courses.course_no, courses.title, courses.credits, course_offerings.semester,course_offerings.yr, course_offerings.section_no, course_offerings.room, course_offerings.time FROM courses,course...
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