I am currently doing a select statement on get the contact person and business name by referring to one column value
Table 1 has the full name of the user name :
user name id short term
sally kiu 123 slyk
owen ku 456 owk
Table 2 have the issue number, the contact person , and the business contact in the short form :
issue number contact person business
103 slyk slyk
789 owk slyk
My target result is
issue number contact person business
123 sally kiu sally kiu
789 owen ku sally kiu
How to write the query with select statement for my target result.
Thank you