OK - I am stuck again
The following query runs fine in Navicat but I am struggling to make it work in MySQL field.
SELECT
CASE rms_schedule.shifttype WHEN 1 THEN "Day" ELSE "Night" END AS "Shift",
rms_schedule.datestart AS "Start Date",
rms_schedule.datefinish AS "End Date",
rms_schedule.notes AS "Notes",
rms_clients.client_name AS "Client",
rms_stores.address AS "Address",
rms_stores.town AS "Town",
rms_stores.county AS "County",
rms_stores.postcode AS "Postcode",
rms_stores.tel_no AS "Telephone"
FROM
rms_schedule
LEFT JOIN rms_stores
ON rms_schedule.record_id = rms_stores.record_id
LEFT JOIN rms_clients
ON rms_stores.client_id = rms_clients.client_id
WHERE user_id = 44 AND datestart >= CURDATE()
I have tried removing AS "Xxxxxx" and leaving just the fields - no output.
I also tried removing the LEFT JOIN's from the query - no output.
Navicat runs the query and displays the single record that currently matches the query when I change {USERID} for the actual number e.g. 44
Also tried the variants from {USERID} to {VIEWERID} access to all, User, Viewer. Set Limit 0,10 removed limit entirely but cannot get this to work.
Any ideas where I am going wrong?