SQL query showing missing expression
- by Ashok Dasari
Query to pull the data between Yseterday 6AM to today 6AM ...
SELECT
lot_id,
log_time,
batch_no,
eqp_id,
STATION_ID,
EXTRACTVALUE (META_DATA, '/lot_info/A3') AS A3,
EXTRACTVALUE (META_DATA, '/lot_info/A3Info') AS A3Info,
EXTRACTVALUE (
META_DATA,
'/lot_info/apc_status_info'
) AS apc_status_info
FROM
…