I want to get rows from child and from it's child table in MySQL.
Supposed I have the following tables with their columns:
id name created
id tableA_id created
- table A is the parent table
- table B is child of table A
table C is child of table B
tableA_idis foreign key to table A
tableB_idis foreign key to table B
Basically, I just want to get rows from
- table B where created from table A is 30 days older
- table C where id not exist in table B
Is this possible? Any suggestion is appreciated.