Xin l?i nh, v c?n g?p m?i chuy?n qua Box ny .... khi no xong s? xo lun Cho cc d/c ... t? dang m?c ? ph?n ny ... cao th? Access no c cao ki?n ch? gio nh .... urgent 1. Doctor table g?m cc c?t: DoctorID, FirstName, LastName, SpecialistArea trong d DoctorID l primary key 2. Treatment table g?m cc c?t: PatientID, TreatmentDescription, DoctorID, TreatmentDate, TreatmentTime ... trong d PatientID l primary key 3. Relationship gi?a Doctor Table v Treatment Table l 'one-to-many', m?t bc si ? [Doctor]![DoctorID] c th? c >= 1 Patient ho?c c th? khng c Patient no. Question: Thi?t l?p Query (dng 'subquery') cho bi?t DoctorID, FirstName, LastName v SpecialistArea c?a nh?ng bc si khng c b?nh nhn no Xin chn thnh thank you .... mong cc cao th? s?m gi?i dp h? "I kiss you ... goodbye" Được sửa chữa bởi - milou on 10/10/2001 06:28
SELECT * FROM Doctor WHERE DoctorID NOT IN (SELECT DISTINCT DoctorID FROM Treatment) không bi?t dúng syntax c?a Access không n?a, th? nhé
