
I need to return three lines:
1- meat / carne
2- meat / boi
3- meat / boi gordo
How can I do that?

I need to return three lines:
1- meat / carne
2- meat / boi
3- meat / boi gordo
How can I do that?
While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)
You made this post useless for others.
Without a minimal reproducible example, nobody can take Viorel's answer, run it, test it, understand it, and apply it in their environment.
10 people are following this question.