newbie needs help, what is this called

[hollyh]

Okay so this isn't even pretending to work

SELECT subquery_Analysis_PrePregMedications.ID, subquery_Analysis_PrePregMedications.[Visit Type], subquery_Analysis_PrePregMedications.BetaBlocker, subquery_Analysis_PrePregMedications.Diuretic, subquery_Analysis_PrePregMedications.Anticoagulation, subquery_Analysis_PrePregMedications.AceInhibitor, subquery_Analysis_1stMedications.[Visit Type], subquery_Analysis_1stMedications.BetaBlocker, subquery_Analysis_1stMedications.Diuretic, subquery_Analysis_1stMedications.Anticoagulation, subquery_Analysis_1stMedications.AceInhibitor, subquery_Analysis_2ndMedications.[Visit Type], subquery_Analysis_2ndMedications.BetaBlocker, subquery_Analysis_2ndMedications.Diuretic, subquery_Analysis_2ndMedications.Anticoagulation, subquery_Analysis_2ndMedications.AceInhibitor, subquery_Analysis_3rdMedications.[Visit Type], subquery_Analysis_3rdMedications.BetaBlocker, subquery_Analysis_3rdMedications.Diuretic, subquery_Analysis_3rdMedications.Anticoagulation, subquery_Analysis_3rdMedications.AceInhibitor
FROM subquery_Analysis_1stMedications, subquery_Analysis_2ndMedications, subquery_Analysis_3rdMedications, subquery_Analysis_PrePregMedications;

for this i was trying to add

WHERE subquery_Analysis_PrePregMedications.ID= subquery_Analysis_1stMedications.ID=subquery_Analysis_2ndMedications.ID

..etc

but it freezes so I know i must be wrong. Am I even getting in the right direction.. I need read about joins I guess.