SQLTeam.com | Weblogs | Forums

Help writing a quick query HELP!

need help writing a statement that would pull Account , Facility , City , and PatientLast for the Atlanta Facility only. Primary key for both is Account

CREATE TABLE Location (
Account VARCHAR(6),
Facility TEXT(10),
PRIMARY KEY ( Account )
INSERT INTO 'Location' (Account, Facility)
VALUES ('A12385', 'Atlanta', 'A45643', 'Atlanta', 'C45644', 'Cherokee', 'F98978', 'Forsyth');

CREATE TABLE Demographics (
Account VARCHAR(6),
PatientLast TEXT(10),
City TEXT(15),
PRIMARY KEY ( Account )
INSERT INTO 'Demographics' ('Account', 'PatientLast', 'City')
Values ('A12345', 'Smith', 'Atlanta' , 'A45643', 'Jones', 'Dunwoody', 'C45644', 'Brown', 'Canton', 'F98978,''Webb', 'Cumming',);

Again, need help writing a statement that would pull Account , Facility , City , and PatientLast for the Atlanta Facility only. Primary key for both is Account

Thanks for your help!!!