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.
