how to join a table with two table
hi
I am trying to join two table to another table but when I press Test button its displaying no data in fact tables have data. here is sql query code
SELECT menu.*, pages.*, menu_category.*
FROM menu INNER JOIN pages ON menu.page_id = pages.id INNER JOIN menu_category ON menu.menu_category = menu_category.id
ORDER BY menu.position ASC
tell me whats wrong?