child not displaying correctly
I created a data model using Model Database. The database I am using is defined using the Dynamic My SQLi Connection and test is successful. I have a categories table and an inductees table, where there is 1 unique category title in the categories table, but many inductees could also be tagged with that category. I created a MySQLi Recordset titled category. In the advanced mode, I used the Query Builder to create the SQL statement
"SELECT inducteecat.*, inductees.*
FROM inducteecat INNER JOIN inductees ON inducteecat.category = inductees.category LIMIT 1"
When run the test, the SQL statement returns 60 records which is how many inductees I have. But data in the columns reported is not correct. The category field from the category table matches the category field in the inductee's field, but the inductees last name, class year and image name are blank, and the firstname field is reporting the inductees class year. What do you think is happening?