From the course: Oracle Database 12c: Basic SQL
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Joins with table aliases - Oracle Database Tutorial
From the course: Oracle Database 12c: Basic SQL
Joins with table aliases
- [Instructor] Note that when writing sequel queries utilizing joins you can also leverage aliases for your tables. For example we can type select first name, department name from employees and give the table an alias such as emp join departments and give the table an alias such as dept on emp.department id equals dept.department id. When executing this query we'll get our result as expected. But now that I've specified the table alias for both the employees table as well as the departments table. That's because I've provided an alias of emp for the employees table and an alias of dept for the departments table.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.