JamesonJendreas
asked on
MySQL - Join tables
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.