Zoologico(SOLOLEARN)

Question

Como hago para ver la tabla que uni a través del Inner join y mostrar las columnas que me pide el ejercicio
Ya uni la tabla pero no logró mostrar la segunda columna de la segunda tabla "countries" ¿al juntar las 2 tablas tengo que renombrarla? y así crear una CREATE VIEW?

Answer 1

How do I see the table that joins through the Inner join and show the columns that the exercise asks me for I already joined the table but did not modify to show the second column of the second table "countries" when joining the 2 tables do I have to rename it? and so create a CREATE VIEW?

Answer 2

Hi, if you want to help more people please wirte the post in English language

Answer 3

If the field name is unique among the joined tables then you may just select the field name. If more than one table use the same field name then you would distinguish the field with select <table name>.<field name>.