[GENERAL] HELP, how to make this query.

*select j.kode_barang kode_barang,j.isi_Satuan from J_master_barang j **order by j.kode_barang asc* *display * kode isi 01 24 01B 12 01C 1 i want to make that become when i select my table.how to make this. kode isi_A i

[GENERAL] how to make select for multiunit

hello ... i have stock table all stock in smallest unit ( PCS ) i have stock table like this name qty unit PCA 20 PCS MOUSE 25 PCS i have table unit 1 KRT = 12 PAK 1 PAK = 10 PCS how to make select to display report stok in dbGRID like this : PCA 2 KRT 0 PAK 0 PCS MOUSE 0 KRT 2 PAK 1 PC