Mestinya...
Select Kode,Barcode As Bottle,'' As Kotak From Barcode Where Type = 'B'
Union All
Select Kode,'' As Bottle, Barcode As Kotak From Barcode Where Type = 'K'
-----Original Message-----
From: Ananto Suprajitno [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 11:06 AM
To: [EMAIL PROTECTED]
Subject: Re: [Delphindo] Perintah SQL untuk menampilkan hanya 1 kondisi saja
Waaaahhhh....
Setelah saya coba kok pada kolom Kotak nggak ada isinya alias semua barcode
masuk pada kolom botol Gimana yah....?
SQL yang saya ketik :
Select Kode,Barcode As Bottle,'' As Kotak From Barcode Where Type = 'B'
Union All
Select Kode,Barcode As Kotak,'' As Bottle From Barcode Where Type = 'K'
>
> Nih....
>
> Select kode, barcode as Botol, '' as Kotak
> >From TableAnda
> Where Tipe = 'B'
> Union all
>
> Select kode, '' as Botol, barcode as Kotak
> >From TableAnda
> Where Tipe = 'K'
>
>
> Hallo rekan DELPHIER...
> Saya punya problen sbb:
> saya punya field :
> 1. Kode (2 dgt)
> 2. Barcoode (15 dgt)
> 3. Tipe (1 dgt)
>
> Pada field Tipe, hanya akan berisi "B" (Botol) atau "K" (Kotak).
> contoh datanya
> Kode Barcode Tipe
> ----------------------------------------------------------------------
> ----
--
> ---------
> A1 1111111111 B
> A2 22222222222 K
>
> Pertanyaan saya, bagaimana perintah SQL untuk menampilkan tabel spt ini:
>
> Kode Botol Kotak
> ----------------------------------------------------------------------
> ----
--
> ---------
> A1 1111111111
> A2 22222222222
>
> Teng Kyu atas info yang diberikan nantinya...
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/i7folB/TM
--------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED] Yahoo!
Groups Links
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Delphindo/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
