I need to create one table from 3, for now, and I followed the instructions on a couple of websites and in my books but as I thought I had finished, an error appeared at the beginning (. Msg 102, Level 15, State 1, Incorrect syntax near '('. I tried everything I can think of but I don't see the problem. It's a little long...but here's the code: I had to remove PHI so the Where clause has no values as criteria here.
Create Table OPVisits
AS (Select OrganizationMRN, LastNM, FirstNM, VisitID
FROM Patient.PatientInternalOrganizationBASE, Person.PersonBASE, Encounter.VisitBASE
WHERE OrganizationMRN in THERE ARE ABOUT 25 SEPARATE VALUES HERE, ALL IN SINGLE QUOTES...and Encounter.VisitBASE.VisitID is not null);