Use + to concatenate two columns. For example:
SELECT DeviceMgf.MfgName + ' ' + DeviceModel.ModelName AS Device, DeviceModel.ModelID
FROM DeviceMfg INNER JOIN DeviceModel ON DeviceMfg.MfgID = DeviceModel.MfgID
ORDER BY Device
FROM DeviceMfg INNER JOIN DeviceModel ON DeviceMfg.MfgID = DeviceModel.MfgID
ORDER BY Device
Adding + ' ' + will concatenate the two columns and put a space in between them.
Add to favorites
