contoh :
A
==
1
2
3
B
=
3
4
5
kalau A union B hasilnya (1,2,3,4,5)
kalau A unionall B hasilnya (1,2,3,3,4,5)
pakai union/all krn mau gabungin 2 query,
query yang ada status approve,
query yang baris pertama yang ga ada status approve
cmiiw,
firman
aly rmb <[EMAIL PROTECTED]> wrote:
Sebelumnya terimakasih atas semua yg telah merespon email ini.
setelah di test, hasilnya sama spt data aslinya ...
sorry, bukannya "Union"/ "Union All" itu untuk menggabungkan 2 queries ?!
tks/Aly
[EMAIL PROTECTED] wrote:
coba saya bantu,
select * from(
select User_id User_name Seq Status from tabel
where status='Approve'
union all
select User_id User_name Seq Status from tabel
where (status is null and seq=1)
) order by User_id
salam,
adhi
aly rmb <[EMAIL PROTECTED]>
Sent by: [email protected]
23/10/2007 15:13
Please respond to
[email protected]
To
[email protected]
cc
Subject
[indo-oracle] Query table
Hi .....
ada data spt di bawah :
User_id User_name Seq Status
---------------------------------------------------------
1 A 1
1 B 2 Approve
2 C 1
2 D 2
3 E 1
3 F 2 Approve
3 G 3
yg ingin di hasilkan
1 B 2 Approve
2 C 1
3 F 2 Approve
Klo Statusnya ngga' ada yg Approve, maka Seq = 1 yg akan di tampilkan
Tolong pencerahannya donk ....
.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
