Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Query

Author

Topic

wandy910
Starting Member

11 Posts

Posted - 2008-09-03 : 20:32:35

dear all

can everbody give me solution to fix my problem, i have table "BELI",JUAL" the query that i want to show like this

KODE NM_BRG TGL_BELI JMLH_BELI TGL_JUAL JMLH_JUAL
001 TEST 02/08/08 2
001 TEST 03/08/08 2
002
003
004
005

i was try to make query using right and left join but it didnt work the result query like this when i used right and left join :

KODE NM_BRG TGL_BELI JMLH_BELI TGL_JUAL JMLH_JUAL
001 TEST 02/08/08 2
001 TEST 02/08/08 2 03/08/08 2
002
003
004
005

can everbody help me?? please i need backup. i will greatful for this. thx

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-03 : 22:48:56

You haven't provided enough information for us to help you. Show us the tables.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

wandy910
Starting Member

11 Posts

Posted - 2008-09-03 : 23:20:37

table barang
1. kode
2. nm_brg
3. jmlh_brg

table beli
1. id_beli
2. kode
3. jmlh_beli
4. tgl_beli

table beli
1. id_beli
2. kode
3. jmlh_beli
4. tgl_beli

thx for your help.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources