| Mhon bantuan utk membuat query mysql, 3 tabel jadi 1. Agar lebih jelas lihat di ilustrasi gambar.
Yang mau bikinin query mysqlnya, ane kasih pulsa 50rb. serius. Bikin contoh file + databse-nya. |
|
| Direlasikan dg inner join bruw |
|
| bs minta arahan scriptnya? |
|
| soalnya udah baca-bca buku, cari2 di om gogel, msh blm ktm jg. |
|
| ane kasih pulsa 50rb utk yg mw bkinin query mysql-nya, contoh file php ama databasenya. |
|
| serius, bth bntuan. |
|
| pls help |
|
| udh bs blm bro |
|
| blh aq bantu bro |
|
| coba add aq bro aq gak bs add friend nih.. |
|
| kalau ane lebih milih ngebuat 2 tabel aja... table "pesan" dan tabel "jenisPesan".. "pesan", fields: 1. idPesan 2. noTlp 3. waktu 4. isiPesan 5. idJenis
"jenisPesan", fields: 1. idJenis 2. jenisPesan
query "select pesan.waktu, pesan.noTlp, pesan.isiPesan, jenisPesan.jenisPesan from pesan inner join jenisPesan on pesan.idJenis = jenisPesan.idJenis order by pesan.waktu desc" |
|
| intinya gini bro query nya : select tabel1.*, tabel2.*, tabel3.* from tabel1 on tabel2 left join tabel2 on tabel3 left join tabel1 on tabel3 (nmrku 089682145551) |
|
| Malang Ngalam : blm bs, aku jg gk bs add ke agan Andri Rosandi : database yg ada skg seperti itu, dan itu gk bisa dirubah karena bawaan aplikasinya, kalo dirubah gak bisa update lg nantinya. |
|
| ada kontak gtalk or ym bro biar enak komunikasi nya ;) |
|
| ym ke irwanz8910 |
|
| udh aq add bro |
|
| Select InsertDateTime as DateTime,DestinationNumber as PhoneNumber,SMS as SMS, 'outbox' as Folder FROM outbox union all Select ReceivingDateTime as DateTime,SenderNumber as PhoneNumber,SMS as SMS, 'inbox' as Folder FROM inbox union all Select SendingDateTime as DateTime,DestinationNumber as PhoneNumber,SMS as SMS, 'sentitems' as Folder FROM sentitems order by DateTime desc;
belum sempurna, tp silahkan dicoba .. semoga membantu .. |
|
| udah terselesaikan sama Hendra Effendi... |
|
| tinggal sedikit lagi mas , masih belum bisa buat folder outbox record always on top .. silahkan disempurnakan lagi .. |
|
| Select InsertDateTime as DateTime,DestinationNumber as PhoneNumber,SMS as SMS, 'outbox' as Folder FROM outbox union all Select ReceivingDateTime as DateTime,SenderNumber as PhoneNumber,SMS as SMS, 'inbox' as Folder FROM inbox union all Select SendingDateTime as DateTime,DestinationNumber as PhoneNumber,SMS as SMS, 'sentitems' as Folder FROM sentitems order by DateTime and folder desc; |
Tidak ada komentar:
Posting Komentar