I want to ask something that I know that rather it is not possible.
I have a table (categories) that has a foreign key to thatself.(one->many).
I want to take all the chain of a category (A category and all the subcategories).It is possible with a single view?
I thing it is possible with a Stored Routine.