Categories
Uncategorized

Maintenance MySQL – Job Sheets Android: jobsheet_report_open

CREATE VIEW jobsheet_report_open AS
SELECT * FROM jobsheet_report_last_entry
WHERE jr_jobcomp=0
OR jr_jobcomp IS NULL ;

Leave a Reply

Your email address will not be published. Required fields are marked *