Hello all.
I hope someone can help me out with this challenge.
I have three tables in my database
one called
cms_packages
another called
cms_features
and a linking table called
cms_package_features
the table structures look like this
cms_package
>package_id (pk)
>package_title
>package_dscpn
cms_feature
>feature_id (pk)
>feature_title
>feature_dscpn
cms_package_feature
>package_id (fk)
>fetaure_id (fk)
Now i can never get my head round this always seem to come unstuck.
What i want to do is list all the packages with the features including the features that package hasn’t got.
so i can end up with a table looking like this.
packages --> (running along top)
feature 1 |x|x|x|x|o|
feature 2 |x|x|o|x|x|
feature 3 |x|x|o|x|x|
feature 4 |x|o|o|x|x|
feature 5 |x|x|o|o|x|
Now from what i gather i’m supposed to be using left joins but i can’t for the life of me get it to look like my example.
Can anyone help please?
