I would like to display information from the tbl_Pass table based on a value from the tbl_Ship table. This will occur multiple times in my ASP page.
I have a view_ship.asp request that displays the original person that submitted the ship request as well as the last person to modify the request. I can display the tbl_Ship.ID_P and the tbl_Ship.ID_P_Mod however I want to display the actual name instead of the ID. My initial thought is have the SQL statements separate for each occurrence however I am not sure how to do this in ASP classic.
Table Structure for tbl_Pass:
Table Structure for tbl_Ship: