SELECT * FROM roctypes;
SELECT * FROM robtypes;
SELECT * FROM smpos WHERE 1;
SELECT smserial, stack, layer, roctype, rocserial, date FROM rocpos WHERE 1;
SELECT * FROM robpos WHERE 1;
SELECT * FROM dcspos WHERE 1;
SELECT rp.roctype,rp.rocserial,rp.position,rp.robserial,dp.dcsserial
FROM robpos AS rp, dcspos AS dp
WHERE rp.robserial=dp.robserial;
SELECT roc.smserial, roc.stack, roc.layer, roc.roctype, roc.rocserial, rob.position, rob.robserial
FROM rocpos AS roc, robpos AS rob
WHERE roc.roctype=rob.roctype AND roc.rocserial=rob.rocserial AND roc.smserial='01'
ORDER BY rob.robserial;
