Here's an interesting bit of code you can try:

CREATE TABLE #Doctors

(ID INT IDENTITY, Name VARCHAR(100), Practice VARCHAR(100), [Views] INT)

CREATE TABLE #DoctorInfo

(Name VARCHAR(100), OfficeDays VARCHAR(10))

INSERT INTO #Doctors

SELECT 'Dr. Dwain', 'Gynecology', 0 UNION ALL SELECT 'Dr. Jeff', 'General Practitioner', 0

INSERT INTO #DoctorInfo

SELECT 'Dr. Dwain', 'Monday'

UNION ALL SELECT 'Dr. Jeff', 'Tuesday'

UNION ALL SELECT 'Dr. Dwain', 'Tuesday'

UNION ALL SELECT 'Dr. Jeff', 'Wednesday'

GO

UPDATE d

SET [Views] = [Views] + 1

OUTPUT INSERTED.*, a.OfficeDays

FROM #Doctors d

INNER JOIN #DoctorInfo a ON a.Name = d.Name

WHERE ID = 1+ ABS(CHECKSUM(NEWID())) % 2

GO 5

SELECT * FROM #Doctors

DROP TABLE #Doctors, #DoctorInfo

If you can't figure out what it is doing let me know and I'll explain. But strangely you can dump the information from JOINed tables in the OUTPUT clause.

You cannot however, add any JOINs after the composable DML solution I suggested.