Just asking on how to view a foreign key in 3 tables.
I have attached a pictured, in the picture, in the shape table there is a foreign key object_id from object. and the object have a foreign key color_id and it is connected to color.
In the color_id of the object I will get the color_name from the color.
while in the in object_id in the shape I will not get the object_name but rather the color_name of the color that the oject get from the color.
I want to get the color_name without connecting the shape from the color