I have 2 table and 1 query, like this picture below:
The query said:
Expand|Select|Wrap|Line Numbers
- SELECT A1, (SELECT COUNT(C1) FROM Table1 WHERE Table2.ID=Table1.C1 OR Table2.ID=Table1.C2) AS Total
- FROM Table2;
Am sory for my bad english, i hope you understand. Thank you