Skip to content

Instantly share code, notes, and snippets.

View blakewrege's full-sized avatar

blake blakewrege

View GitHub Profile
SELECT * from (enrolled left join class
on enrolled.cname=class.cname)
union
SELECT * from (enrolled right join class
on enrolled.cname=class.cname);
SELECT *from (class left join faculty
on class.fid=faculty.fid)
union
SELECT * from (class right join faculty
π names σ zip = 49008 U zip = 49009 (zip codes)