[belajar-access] Re: Query Sederhana

 

Dear Mas Sarma,

SELECT Table1.Field1
FROM Table1 LEFT JOIN Table2 ON Table1.Field1 = Table2.Field1
WHERE (((Table2.Field1) Is Null));

Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
http://imopi.wordpress.com/

--- In belajar-access@yahoogroups.com, sarma diaz <sh.ronald@...> wrote:
>
> 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 (2)

Recent Activity:

• New Members 10

Visit Your Group

SPAM IS PROHIBITED

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

.

__,_._,___