Patients Living in Lamont

[swt027]

[FONT="Calibri",sans-serif]Query Question: D[/FONT][FONT="Calibri",sans-serif]isplay the number, last name, first name, andaddress of patients living in Lamont.
My answer
[/FONT]
SELECT Patient_number, Patient_lastname, Patient_firstname, Patient_address
From Patient_table


Where Customer_state = "Lamont"

I only have two tables, Patient Table and Therapist Table. Something is wrong though, it is populating a box asking me for patient last name.

Please help!

[CJ_London]

means you don't have a field called Patient_lastname in your table called Patient_table

[swt027]

I see now! Thank you!!!