Arsip: Select LIMIT PLEASE HELP URGENT........
more 12 years ago
Tyu_alone
Gini ane punya masalah gan.
tb_satu
ID | LOGIN | NILAI
============
1 | 1 | 100
2 | 1 | 200
3 | 1 | 300
4 | 1 | 400
5 | 1 | 500
6 | 1 | 600
7 | 1 | 700
8 | 2 | 100
9 | 2 | 200
10 | 2 | 300
11 | 2 | 400
12 | 2 | 500
tb_dua
LOGIN | BATAS
============
1 | 2
2 | 3
Ane pengennya nampilin kayak gini gan hasilnya
tb_result
ID | LOGIN | NILAI
============
1 | 1 | 100
2 | 1 | 200
8 | 2 | 100
9 | 2 | 200
10 | 2 | 300
Mohon pencerahannya gan.
terima kasih
more 12 years ago
Tyu_alone
[quote:eef09bc531="Tyu_alone"]Gini ane punya masalah gan.
tb_satu
ID | LOGIN | NILAI
============
1 | 1 | 100
2 | 1 | 200
3 | 1 | 300
4 | 1 | 400
5 | 1 | 500
6 | 1 | 600
7 | 1 | 700
8 | 2 | 100
9 | 2 | 200
10 | 2 | 300
11 | 2 | 400
12 | 2 | 500
tb_dua
LOGIN | BATAS
============
1 | 2
2 | 3
Ane pengennya nampilin kayak gini gan hasilnya
mohon pencerahannya untuk buat sqlnya ya gan...
untuk CREATE VIEW tb_result AS....
tb_result
ID | LOGIN | NILAI
============
1 | 1 | 100
2 | 1 | 200
8 | 2 | 100
9 | 2 | 200
10 | 2 | 300
Mohon pencerahannya gan.
terima kasih[/quote:eef09bc531]
ini maksudnya apa seh?? pake quote2, punya sendiri lagi... by mas_kofa
more 12 years ago
madi
ID | LOGIN | NILAI
============
1 | 1 | 100
2 | 1 | 200
8 | 2 | 100
9 | 2 | 200
10 | 2 | 300
untuk menghasilkan query spt itu, syaratnya apa saja
more 12 years ago
Tyu_alone
sebenarnya hanya menampilkan tb_satu, tetapi jumlah record ditentukan oleh batas yangada di tb_dua
kalo boleh ane coba sprti ini gan,
[sql]select login, nilai, 0 as batas from tb_satu, tb_dua where tb_satu.login=tb_dua.login
union all
select login, nilai, batas from tb_dua limit 0,"hasil_dari_batas"[/sql]
tapi kayaknya kliru gan,bisa bantu ane gan,pliss....
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
- TDBGRID
by budi_bunga in Enginering more 17 years ago - Cari tutorial Delphi dan lain-lain ?
by EkoIndri in Tutorial & Community Project more 17 years ago - Fast Report Print Stringgrid menentukan posisi alignment
by JalmaLier in Reporting more 14 years ago - Converence ?
by umarbakri in Hal umum tentang Pascal Indonesia more 17 years ago - Update Database kenapa gak bisa ??
by flamade in Tip n Trik Pemrograman more 16 years ago - TMU Printer komponen u/ printer kasir & dot matrik
by MrLee in Reporting more 15 years ago - tanya:datamining
by frigs in Enginering more 17 years ago - Problem dengan master detail
by iwancs in Bedah Kasus more 13 years ago - report yg sesuai keinginan kita
by goodday in Reporting more 18 years ago - Lazarus 0.9.20 (beta) Released!
by simba in onLinux more 17 years ago