Skip to content
Advertisement

Trying to count the number of occurences that 3 columns from 2 tables have on my organizations table? I need the occurrences joined in one table

org_id is the foreign key that reals both the users table and topics table. It keeps giving me the wrong result by only either counting the number of admins or standard users and putting that for all rows in the each column. Any help is really appreciated as I have been stuck on this for a while now!

So, I am getting an error when I do as you said which is that the users table cannot be specified more than once. I updated the code to how you said to write it but still nothing. They really don’t give me any sample data either but I just made some queries and saw the number of times there are private topics for example, which is in the privacy column of the topics table. When I dont get this error as I said, the joins seem to overwrite themselves where each row for all the columns is the same as the last join.

Advertisement

Answer

It appears to me that topics and users have no relationship. You’re just trying to get the result together in a single query. There are other and possibly better ways to accomplish that but I think this will fix what you’ve got already (assuming you have id columns for each table.)

I propose this as a more straightforward way:

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement