Bgini bisa gak ? select (select '1' test2 from dual) test1, (select '2' test2 from dual) test2 from dual
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Padang Nadimpu Sent: Tuesday, 08 July, 2008 11:43 PM To: [email protected] Subject: [indo-oracle] Count record dari beberapa table Dear All, Mohon pencerahan sql statement, tentang menampilkan jumlah (count) record dari beberapa table. Saya telah coba dengan script di bawah ini, tetapi record yang ditampilkan masih per table select count (*) from biodata; select count (*) from dtkeluarga select count (*) from lahir; select count (*) from mati; select count (*) from kawin; select count (*) from cerai; select count (*) from pindah; Sementara tampilan data/record yang inginkan sebagai berikut : biodata dtkeluarga lahir mati kawin cerai pindah --------- ------------ ------ ------- -------- ----- -------- Thx Padang Nadimpu [Non-text portions of this message have been removed]
