gue coba dulu, kalo salah maklum ya...:D
select k.no_id, k.nama, j.jenis, k.alamat, k.no_telp, g.gudang from
konsumen k, jeniskons j, gudang g where (k.jenis = '1' or k.jenis =
'3') and g.nama = 'promosi'
maaf, kalo salah ya...
--- In [EMAIL PROTECTED], "Arman Maulana" <[EMAIL PROTECTED]>
wrote:
> Hai teman teman saya NEWBIE tentang SQL
> saya boleh tanya sedikit tentang SQL ya.. please.. help me..
> yang saya pakai engine MySQL
>
> masalahnya seperti ini
> saya punya 3 table..
>
> 1. nama table = konsumen
> +------+----------+-------+----------+ ----------+---------+
> | no_id | nama | jenis | alamat | no_telp |
gudang |
> +------+----------+-------+----------+ ----------+--------+
> | 1 | rini | 1 | tomang | 42342 |
2
> |
> | 2 | budi | 3 | slipi | 231231 |
2
> |
> | 3 | banu | 3 | depok | 12312 | 3
> |
> | 4 | sanusi | 2 | cinere | 56211 |
2
> |
> | 5 | iwan | 1 | cilandak | 1232 |
1
> |
> | 6 | hasbi | 2 | ciledug | 56211 |
3
> |
> | 7 | komar | 3 | ps.minggu | 12212 | 4
|
> | 8 | dewi | 4 | tangerang | 56211 | 2
|
> | 9 | bangun | 3 | ps.minggu | 12212 | 2
|
> | 10 | fara | 4 | joglo | 56211 |
3
> |
> +------+----------+-------+----------+ ----------+-------+
>
> 2. nama table = jeniskons
> +-------+-----------+
> | no_id | nama |
> +-------+-----------+
> | 1 | distributor |
> | 2 | tradisional |
> | 3 | horeka |
> | 4 | lainnya |
> +-------+----------+
>
> 3. nama table = gudang
> +-------+-----------+
> | no_id | nama |
> +-------+-----------+
> | 1 | utama |
> | 2 | promosi |
> | 3 | horeka |
> | 4 | event |
> +-------+----------+
>
>
> yang saya mo tanyakan.?
> bagaimana caranya mo mendapatkan
> hasil tampilan report tampilan
> nama konsumen hanya berjenis 1 dan 3 pada gudang nomor 2
>
> hingga seperti ini..
>
> +------+----------+------------+----------+
----------+--------------+
> | no_id | nama | Jenis | alamat | no_telp
| gudang
> |
> +------+----------+------------+----------+
----------+--------------+
> | 1 | rini | distributor | tomang | 42342
|
> promosi |
> | 2 | budi | horeka | slipi |
231231 |
> promosi |
> | 9 | bangun | horeka | ps.minggu | 12212 |
promosi
> |
> +------+----------+-------------+----------+
----------+--------------+
>
> berkenankanlah teman2x menyarankan SQL yang efektif untuk tampilan
seperti
> itu..
> ( saya dah pake join dan left join namun belum ketemu.. tolong ya..
)
> terutama kepada Bpk. Shomad. yang jago SQLnya..
> terima kasih Sebelumnya..
>
> Salam
>
> Arman Maulana
------------------------ Yahoo! Groups Sponsor --------------------~-->
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/IHFolB/TM
--------------------------------------------------------------------~->
----------------------------------------------------------
Komunitas MasterWeb Indonesia http://www.master.web.id
----------------------------------------------------------
MWN, Masternya WEBHOSTING di Indonesia, Indo/USA Servers,
Customer Support 24 jam http://www.masterwebnet.com
----------------------------------------------------------
Sekolah Digital Design Terlengkap http://www.mwschool.com
----------------------------------------------------------
WebDevelopment,Designing/Programming http://www.dlanet.com
----------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/milis-masterweb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
