course{ course_id, course_name, } subject{ subject_id, subject_name, course_id } student{ email, course_id, } This is my code , It display all the subjects belongs to the course $_GET['email_address']=$_SESSION['email_address']; $sql="(SELECT c.course_name course_name,su.subject_name subject_name from subject su LEFT JOIN course c ON…
I trying to create a filter output of images by joining five tables. I need the five tables joined because of my where statements. My sql is the following: SELECT `files`.`id` AS `id`, `files`.`name` AS `name`, `files`.`size` AS `size`, `files`.`type`…
1st query; both tables contain all categories_ids SELECT * FROM categories c, categories_description cd WHERE c.categories_id = cd.categories_id ORDER BY sort_order, cd.categories_name 2nd query; this table maybe hold a categories_id SELECT count(*) AS total FROM products_to_categories WHERE categories_id = "'+…