Code:
SELECT tbl1stdeBASE.StudyID, tbl1stdeBASE.Date_consent_signed, tbl1stdeBASE.Visit_date, tbl1stdeBASE.Aged_between_18_and_75, tbl1stdeBASE.Chronic_low_back_pain, tbl1stdeBASE.First_consultation, tbl1stdeBASE.NRS, tbl1stdeBASE.ODI, tbl1stdeBASE.Lumbar_multifidus_muscle_dysfunction, tbl1stdeBASE.Informed_consent, tbl1stdeBASE.Able_to_comply, tbl1stdeBASE.Indicated_for_reactiv8, tbl1stdeBASE.BMI, tbl1stdeBASE.Leg_pain, tbl1stdeBASE.Sacroiliac_joint_pain, tbl1stdeBASE.Scoliois, tbl1stdeBASE.Neurological_deficit, tbl1stdeBASE.Opioids, tbl1stdeBASE.Medications, tbl1stdeBASE.Rhizotomy, tbl1stdeBASE.Block, tbl1stdeBASE.Previous_back_surgery, tbl1stdeBASE.Previous_thoracic, tbl1stdeBASE.Litigation, tbl1stdeBASE.Claim, tbl1stdeBASE.Depression, tbl1stdeBASE.Diagnosed, tbl1stdeBASE.Planned_surgery, tbl1stdeBASE.Eligible, tbl1stdeBASE.Consent_obtained, tbl1stdeBASE.Age, tbl1stdeBASE.Gender, tbl1stdeBASE.Height, tbl1stdeBASE.Weight, tbl1stdeBASE.Pain_frequency, tbl1stdeBASE.First_doctor_visit, tbl1stdeBASE.Current_episode, tbl1stdeBASE.Previous_rhizotomy, tbl1stdeBASE.Spine_surgery, tbl1stdeBASE.Receiving_compensation, tbl1stdeBASE.Received_compensation, tbl1stdeBASE.Work_status, tbl1stdeBASE.Ability_to_work, tbl1stdeBASE.BaselineNRS, tbl1stdeBASE.DASS_depression, tbl1stdeBASE.DASS_anxiety, tbl1stdeBASE.DASS_stress, tbl1stdeBASE.DASS_total, tbl1stdeBASE.BaselineODI, tbl1stdeBASE.EQ5D_mobility, tbl1stdeBASE.EQ5D_selfcare, tbl1stdeBASE.EQ5D_usual_activities, tbl1stdeBASE.EQ5D_pain_discomfort, tbl1stdeBASE.EQ5D_anxiety_depression, tbl1stdeBASE.PROMIS29_physical_function, tbl1stdeBASE.PROMIS29_anxiety, tbl1stdeBASE.PROMIS29_depression, tbl1stdeBASE.PROMIS29_fatigue, tbl1stdeBASE.PROMIS29_sleep_disturbance, tbl1stdeBASE.PROMIS29_participate, tbl1stdeBASE.PROMIS29_pain_interference, tbl1stdeBASE.PROMIS29_pain_intensity, tbl1stdeBASE.Current_medications, tbl1stdeBASE.[5min_walk_test], tbl1stdeBASE.Sit_stand_test, tbl1stdeBASE.Adverse_eventsFROM tbl1stdeBASE LEFT JOIN tbl2nddeBASE ON (tbl1stdeBASE.Visit_date = tbl2nddeBASE.Visit_date) AND (tbl1stdeBASE.Date_consent_signed = tbl2nddeBASE.Date_consent_signed) AND (tbl1stdeBASE.[StudyID] = tbl2nddeBASE.[StudyID])
WHERE (((tbl2nddeBASE.StudyID) Is Null));
BTW I find it irritating when sample DBs are posted with loin forms, but without login details, and without some guidance of what we should be looking at.