SELECT hin as 'Health#',
demographic.demographic_no as 'Demographic#',
last_name as 'Last Name',
first_name as 'First Name',
{location}
FROM drugs, demographic
WHERE drugs.demographic_no=demographic.demographic_no
{status}
&& ({location} LIKE '%{search}%'
{searchOption2}
{searchOption3}
{searchOption4}
{searchOption5}
{searchOption6}
)
&& demographic.demographic_no NOT IN (
SELECT demographic_no
FROM dxresearch
WHERE dxresearch.status='A'
&& dxresearch_code IN (
select dxResearchCode
FROM quickList
WHERE quickListName='{register}'
)
)
GROUP BY demographic.demographic_no
ORDER BY demographic.last_name, demographic.first_name;
Ignore
AND LIKE
( AND LIKE
AND LIKE )
OR LIKE
( OR LIKE
OR LIKE )
AND NOT LIKE
( AND NOT LIKE
AND NOT LIKE )
OR NOT LIKE
( OR NOT LIKE
OR NOT LIKE )
Ignore
AND LIKE
( AND LIKE
AND LIKE )
OR LIKE
( OR LIKE
OR LIKE )
AND NOT LIKE
( AND NOT LIKE
AND NOT LIKE )
OR NOT LIKE
( OR NOT LIKE
OR NOT LIKE )
Ignore
AND LIKE
( AND LIKE
AND LIKE )
OR LIKE
( OR LIKE
OR LIKE )
AND NOT LIKE
( AND NOT LIKE
AND NOT LIKE )
OR NOT LIKE
( OR NOT LIKE
OR NOT LIKE )
Ignore
AND LIKE
( AND LIKE
AND LIKE )
OR LIKE
( OR LIKE
OR LIKE )
AND NOT LIKE
( AND NOT LIKE
AND NOT LIKE )
OR NOT LIKE
( OR NOT LIKE
OR NOT LIKE )
Ignore
AND LIKE
( AND LIKE
AND LIKE )
OR LIKE
( OR LIKE
OR LIKE )
AND NOT LIKE
( AND NOT LIKE
AND NOT LIKE )
OR NOT LIKE
( OR NOT LIKE
OR NOT LIKE )
Generic Name
Brand Name
Custom Name
Active and suspended patients
Active patients
Inactive patients
All patients
select quickListName, quickListName from quickList group by quickListName order by quickListName;