Count Records# which not exist in second table

[#1]

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

order_number	city_name
10000004	rüsselsheim
10000008	kiel
10000009	schildow
10000011	mühlenbach
10000012	brandenburg
10000013	schildow
10000014	schildow

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.

[Gysbert_Wassenaar · Accepted solution]

See here for a solution.

[#3]

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

Regards,

Zain.