Re: [belajar-access] Query Sederhana

 

Boleh ikutan,

sederhananya gini pakai unmatceh query

SELECT [Table A].[No]

FROM [Table A] LEFT JOIN [Table B] ON [Table A].[No] = [Table B].[No]

WHERE ((([Table B].[No]) Is Null));

selamat mencoba

---

From: CGSATU <cgsatu@yahoo.com>
To: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
Sent: Saturday, July 14, 2012 9:54 AM
Subject: Re: [belajar-access] Query Sederhana

 

Coba pakai Query yang  Find Duplicates Wizard.

 

Nanti ketemu yang sama, terus membandingkannya bisa lebih mudah

 

Elang

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 (7)

Recent Activity:

• New Members 8

Visit Your Group

SPAM IS PROHIBITED

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

.

__,_._,___