How can I pull in several columns from one table and then line them up with additional columns from related tables.For example, if I had Employees with their ID number and Name from one table, how could I pull up the data from another table with their position info and salary. I'm also interested in how to sort them with buttons. How could I always pull up Employees by ID and then press a button to get only the ones with Position "Front Desk"?
[Table One ][Table Two ]
Employee Id | Name | Employee Position | Salary
123456 | Bob | Front Desk | $15
I'm very new to this so any help would be greatly appreciated. Thank you!