Question on how to use and MSSQL join to create a report from a join of two tables
I have two tables in the AAA database: aaa.dbo.machines and aaa.dbo.machineDetails. Based on the info below, how can I write a query that joins the two tables and queries the machineID, machineName, and location. The machineID in the first table matches entityID in the second table.
# machines table:
002, printserver 001
001, status, on