When I run the below query to my Windows xp machine running mysql 5.0.0-alpha-nt it works fine
When I run it on Linux 5.0.3-beta-standard it fails with the message
msg: specified method is not supported
This query works fine using Navicat 2004 which I believe uses a previous mysql library
Code: Select all
select tt.ndcCode,
DATE_FORMAT(tt.VisitDate,'%Y%m%d')as searchDate,
DATE_FORMAT(tt.VisitDate,'%Y%m')as YearMonth,
sum(Qty) as Used,
pharmacy.pharmacyinventory.stockItem,
pharmacy.pharmacyinventory.reorderLevel,
pharmacy.pharmacyinventory.ExpireFlag,
pharmacy.pharmacyinventory.ndcCode,
pharmacy.pharmacyinventory.Unit,
pharmacy.pharmacyinventory.TradeName,
pharmacy.pharmacyinventory.GenericName,
pharmacy.pharmacyinventory.Strength,
pharmacy.pharmacyinventory.Package,
pharmacy.pharmacyinventory.DoseForm,
pharmacy.pharmacyinventory.Route,
pharmacy.pharmacyinventory.Category,
pharmacy.pharmacyinventory.MasterCategory,
pharmacy.pharmacyinventory.multum_category_id,
pharmacy.pharmacyinventory.currentInventory
from
(
SELECT
diagnosis.VisitDate,
diagnosis.Qty,
diagnosis.ndcCode,
diagnosis.confirmed
FROM
diagnosis
WHERE
(diagnosis.confirmed = 'Y' AND diagnosis.ndcCode != '0' AND DATE_FORMAT(visitDate,'%Y%m%d') >= :parmStartDate AND DATE_FORMAT(visitDate,'%Y%m%d') <= :parmEndDate)
) as tt
INNER JOIN pharmacy.pharmacyinventory ON (tt.ndcCode = pharmacy.pharmacyinventory.ndcCode)
group by tt.ndcCode