| | union where order by dgabung bisa gak? |
|
| | coba aja :D klo nanya gimna, bawah ane lebih tau , hhe |
|
| | Bisa |
|
| | ( SELECT id_guru as pengunjung, tanggal_guru AS tgl FROM tb_kunguru where tgl = now() ) UNION all(
SELECT id_siswa as pengunjung, tanggal_siswa AS tgl FROM tb_kunsiswa where tgl = now() ) order by tgl asc
================== ud bsa tp mugnkin ada cara yg lebih praktis dari itu ? |
|
| | union(bawang) where(dimana) order(pesan) kalau digabung bawang pesannya dimana ya??? just guyon |
|
| | yupz bisa,, |
|
| | apa query ane ud optimal kyk gt? tuh where pa mesti dtulis 2 kali kyk gt? |
|
| | gw baru tau.. ternyata orde by bisa pake 2 perintah order by nama, umur, kelamin |
|
| | SELECT id_guru as pengunjung, tanggal_guru AS tgl, id_siswa as pengunjung, tanggal_siswa AS tgl FROM tb_kunguru, tb_kunsiswa WHERE tb_kunguru.tgl = now() AND tb_kunsiswa.tgl = now() |
|
| | tp ane emg btuh outputnya 2 field (kolom) : pengunjug & tgl makax ane gabungin pake union gan Ardian Adja |
Tidak ada komentar:
Posting Komentar