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/
