Good Day Experts!
I am having a bit of trouble with a SQL query I need to write. It "feels" like the desired result is possible but I am not sure how to get there.
I have a Person table with id and firstname lastname fields. I need to display firstname lastname twice but for different id's. One is for the student id and the other for the teacher id.
Can you help point me in the right direction?