Select tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, tblMonitor.MonitorModel, tblMonitor.SerialNumber, tblMonitor.MonitorManufacturer From tblComputers Left Join tblMonitor On tblComputers.Computername = tblMonitor.Computername Order By tblComputers.Computer