From: Dan Nelson
Date: June 22 2005 10:50pm
Subject: Re: Not sure about Error
List-Archive: http://lists.mysql.com/mysql/185770
Message-Id: <20050622225048.GA49728@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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