How can I Count in multiple table?
How can I Count in multiple table? I have some problem to get the ID which use on another table row. I have three tables. One is category, articles, video. In articles and video there is a column which have category ID. This is the example: Table Categories : id | category_name ------------------ 1 | News 2 | Sports 3 | Art 4 | Horror Table Articles : id | category_id | title ---------------------------------- 1 | 1 | title content 1 2 | 1 | title content 2 3 | 3 | title content 3 4 | 3 | title content 4 5 | 2 | title content 5 Table Video : id | category_id | video_title ------------------------------ 1 | 1 | video title 1 2 | 2 | video title 2 3 | 3 | video title 3 I want to get each category ID already use what time in two other databases. Like this : Category ID 1 is use 3 times Category ID 2 is use 2 times Category ID 3 is use 3 times Category ID 4 is use 0 times What query do I need to use...