Categories
Uncategorized

Maintenance MySQL – Asset Report Android: asset_report_history

CREATE VIEW asset_report_history AS
SELECT DISTINCT y.ar_scandt, y.ar_datedue, y.ar_id, y.ar_barcode, x.al_description, x.al_priloc, x.al_secloc, x.al_terloc, x.al_asset_group, y.ar_itemstatus, y.ar_actiontaken, y.ar_actionleft, y.ar_userid, y.ar_pdaid, y.ar_ts, y.ar_checkrqd, y.ar_changedesc, y.ar_changegroup, y.ar_changepri, y.ar_changesec, y.ar_changeter FROM asset_list x, asset_report y WHERE y.ar_barcode=x.al_barcode;

Leave a Reply

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