Count Records# which not exist in second table

Sat, 12 Jan 2013 15:13:46 GMT

Hi,

I want to find count from table1 which is in green because highlighted order number is not exist in table2, and

same as for table2, both tables are join with order_number.

count result for table1 is 2 and table2 is 3.

Table_1

Table_2

order_number	order_detail_number	product_name
10000004	100000041	jeannie schlüsselanhänger tassel blau
10000004	100000042	jeannie schlüsselanhänger tassel violett
10000011	100000111	campagne regal 14 schubl.119x130,5x33,5c
10000012	100000121	après papierserviette kuh heidi 33x33cm
10000012	100000122	mix it! tischset braun
10000012	100000123	après papierserviette ladies night out
10000009	100000091	good fellows stofftier schwein sitzend
10000008	100000081	shine on tischset silber perlen d36cm
10000008	100000082	shine on serviettenringe silber perlen
10000008	100000083	shine on untersetzer silber perlen d10cm
10000003	100000084	shine on untersetzer silber perlen d10cm
10000007	100000085	shine on untersetzer silber perlen d10cm
10000001	100000086	shine on untersetzer silber perlen d10cm

Please guide me to resolve above counts, thanks is advance.

Regards,

Zain.

Re: Count Records# which not exist in second table

Gysbert_Wassenaar — Sat, 12 Jan 2013 15:29:45 GMT

See here for a solution.

Sat, 12 Jan 2013 16:24:06 GMT

Many many thanks dear Gysbert, and highly appreciate for your quick replay and support to me.

Regards,

Zain.