I have 3 tables, all linked. Table 1, Table 2 and Table 3. 1 to many. Table 1 will always have records in Table 2. However, Table 2 does not have to have any records in Table 3.
I want to get the id's and names of the records in Table 2 for a record in Table 1 only if they have records in Table 3.
here's my query
Now...this returns no records in my php code or phpMyadmin, even though, it worked when I was testing it out in phpMyadmin.
I only want 1 result for each record in Table 2. For example, if a record in Table 2 has 3 records in Table 3, I only want the id and name to show up once in the result. That's why I have the GROUP BY part.
This seems like a simple problem, but I have no idea how to solve it.
Any ideas? Thanks in advance.