OK - wondering if this can be done. I have a MySQL database with 2 tables of information I need. The table names are "Switches" and "SwitchTypes". In the switches table, I am interested in getting a group of fields, "SwitchTypeID, SwitchName, IpAddress and EthernetAddress". SwitchTypeID is a number. The SwitchTypes table contains 2 fields - SwitchTypeID and Description.
Is it possible using a standard query, to select the needed items from "Switches" while subbing in the "Descriptions" in SwitchTypes for the numerical SwiytchTypeIDs?