Charles Baldo
asked on
Need SQL Update
Hi
I have two tables
Create Table Doctor
(
DoctorID as Int,
HasPatients as varchar(1)
)
Create Table Patient
(
PatientID as Int,
DoctorID as Int
)
I need an update that sets Doctor.HasPatients ="Y" if the DoctorID is found in Patients. Many Patients may have the same doctor some doctors will not see patients and therefore have no records in Patient Table
Thank You
I have two tables
Create Table Doctor
(
DoctorID as Int,
HasPatients as varchar(1)
)
Create Table Patient
(
PatientID as Int,
DoctorID as Int
)
I need an update that sets Doctor.HasPatients ="Y" if the DoctorID is found in Patients. Many Patients may have the same doctor some doctors will not see patients and therefore have no records in Patient Table
Thank You
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER