BMGT 402 Lecture Notes - Lecture 9: Foreign Key, Unique Key
Document Summary
Bmgt 402 lecture 9 chapter 6: data manipulation cont. Multi-table queries: also possible to use an alias for a table named in from clause, alias is separated from table name with a space, alias can be used to qualify column names when there is ambiguity. The row count is on the bottom right hand corner. 6. 24: simple join: list name of all the clients who have viewed a property along with any comment supplied. Find the foreign key of one that is the primary key of the other. Where client. clientno = viewing. clientno: this example provides us with 5 results. Where c. clientno = v. clientno; this option is also viable the letter defines the table in a shorter variable the letter is the alias. 6. 25 sorting a join: for each branch office, list staffno and names of staff who manage properties, and the property number and type that they manage.