Re: [belajar-access] Query Sederhana

 

SELECT TableA.Field1, TableB.Field1 FROM TableA LEFT JOIN TableB ON TableA.Field1 = TableB.Field1 WHERE TableB.Field1 Is Null

 

Salam,

Bambang Hartoko

  

---

From: sarma diaz <sh.ronald@yahoo.co.id>
To: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
Sent: Friday, July 13, 2012 1:49 PM
Subject: [belajar-access] Query Sederhana

 

Selamat Siang rekan sekalian,

Mohon dibantu saya mempunyai dua tabel.

Tabel A         Tabel B

1                    1

2                    1

3                    3

4                    5

5

Bagaimana caranya querynya agar Query hnya berisi : 2 dan 4 

(Query C berisi data yang dibandingkan antara Tabel A terhadap Tabel B )

Query C

2

4 

Terima kasih.

Ronald

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity:

• New Members 10

Visit Your Group

SPAM IS PROHIBITED

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___