How to use union all with manual value (not from another tabel)?
Try this:
SELECT csatuan2,csatuan1,nkonversi FROM ms_metriks
UNION ALL SELECT 'LTR','PCS','1'
UNION ALL SELECT 'PCS','LTR','1'
Here is one way you can do it:
SELECT 'LTR' as csatuan1,'PCS' as csatuan2,'1' as nkonversi
UNION
SELECT 'PCS','LTR','1';