In the last episode (Jun 23), Schalk Neethling said:
> I run the following query against MySQL:
>
> SELECT
> demographic_no, first_name, last_name, chart_no, sex,
> year_of_birth, month_of_birth, date_of_birth, family_doctor,
> roster_status, patient_status, phone
> FROM demographic
> JOIN demographic ON allergies.demographic_no = demographic.demographic_no
Do you maybe mean "FROM allergies JOIN demographic ON
allergies.demographic_no ..." ?
> JOIN drugs ON demographic.demographic_no = drugs.demographic_no
> JOIN dxresearch ON drugs.demographic_no = dxresearch.demographic_no
> JOIN echart ON dxresearch.demographic_no = echart.demographicNo
> JOIN ichppccode ON dxresearch.dxresearch_no = ichppccode.ichppccode
> WHERE allergies.description LIKE '%CARBACHOL%'
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
