List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:June 22 2005 10:50pm
Subject:Re: Not sure about Error
View as plain text  
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
	dnelson@stripped
Thread
Not sure about ErrorSchalk Neethling23 Jun
  • Re: Not sure about ErrorDan Nelson23 Jun
    • Re: Not sure about ErrorSchalk Neethling23 Jun