x
SELECT package.pkg_name, pkg.cat_id,pkg.id
FROM pkg
INNER JOIN package ON pkg.id=package.id
join categories ON pkg.cat_id=1=categories.cat_id=1
1st id is show in join table but 2nd id does not show in the join table
Advertisement
Answer
If you are trying to select records where categories id
equals to 1. This should work:
SELECT package.pkg_name, pkg.cat_id, pkg.id
FROM pkg
INNER JOIN package ON pkg.id = package.id
JOIN categories ON pkg.cat_id = categories.cat_id
WHERE categories.cat_id = 1;
This joins all 3 tables together + shows you the record where categories.cat_id = 1