Arsip: help dun:pencarian di bnyk tabel
more 17 years ago
skyblue
gmn yach sintak sql nya klo mo bikin script pencarian untuk bnyk tabel? tabel nya pake paradox. misal yg di cari nama org nah pas nama orang itu di cari hasil yg di tampilkan ada lah semua field yg berhubngan dgn nama itu dari seluruh tabel @.@ thx ya sblmnya
more 17 years ago
hasan_plg
SELECT <alias1>.<field1>,<alias2>.<field1> FROM <tabel1> <alias1>, <tabel2> <alias2>
WHERE <kondisi>
ORDER BY <index>
Contoh:
SELECT st.JB, st.KODE, st.NAMA, st.QTY, jb.KODE, jb.NAMA FROM Stock st, JenisBarang JB
WHERE st.JB = jb.KODE
ORDER BY st.JB, st.KODE
more 17 years ago
skyblue
@hasan
itu untuk nampilin saya juga make kek gitu, nah pas pencariannya yg bingung >_< apakah cari aja disatu tabel gitu ya misal
SELECT kode FROM JB WHERE nama LIKE "%+edit1.text+%"
trus pas nampilin hasil pencariannya pake ini
SELECT st.JB, st.KODE, st.NAMA, st.QTY, jb.KODE, jb.NAMA FROM Stock st, JenisBarang JB
WHERE st.JB = jb.KODE
ORDER BY st.JB, st.KODE
bisa gak kek gitu to ada yg lebih efisien lg nda?
more 17 years ago
hasan_plg
Maaf ya SkyBlue, saya salah mengerti maksud Anda.
Maksud Anda bagaimana ya? Kalo bisa lebih mendetail penjelasan pertanyaan Anda.
more 17 years ago
skyblue
^^ gpp klo nampilin dr semua table saya sudah bisa, nah pas mo bikin script pencarian di semua table agak bingung, ato gin aja pertnyaan saya, mungkin gak membuat script sql untuk pencarian disemua table? klo mungkin, bisa minta cth script nya yg simple
more 17 years ago
skyblue
wah udah dpt mas, setelah baru saja di coba2 lagi akhirnya ktmu juga mas, hnya ditambah AND aja rupanya maaf sudah merepotkan >_< thx y b4
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 3 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 4 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 11 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 11 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 11 years ago
Random Topic
- command out of sync
by yayaretina in MySQL more 16 years ago - [ask] instalshield express
by don2103 in Network, Files, I/O & System more 13 years ago - turn on monitor?
by anosolano in Hal umum tentang Pascal Indonesia more 16 years ago - Fokus Baris Record di DbGrid
by IdrisZZ in Hal umum tentang Pascal Indonesia more 16 years ago - TDBGRID
by budi_bunga in Enginering more 17 years ago - Satu listing program bisa di panggil di beberapa form
by musespratama in Delphi.NET more 12 years ago - (ask) file wave (audio) menjadi binary (bit)
by fajar05 in Enginering more 12 years ago - Mau yang baru
by canoey in Tip n Trik Pemrograman more 18 years ago - Tanya simpan data dari file text ke table
by donlego in Tutorial & Community Project more 17 years ago - Tanya component export
by fissas in Hal umum tentang Pascal Indonesia more 15 years ago