-1
I got three tables on the bench, Exercise and Exercise.
I need to do the SELECT
with the INNER JOIN
and differentiate columns with the same name:
SELECT t.id AS tid, et.id AS etid, e.id as eid, t.data AS tdata, et.data
AS etdata, e.data as edata, *
FROM treino t
INNER JOIN exercicio_treino et
ON et.treino = t.id
INNER join exercicio e
ON e.id = et.exercicio;
What I’d like to know is if it’s right to do it this way or if there’s a more practical way than typing all the columns in SELECT
What does this have to do with "being performative"?
– Marcelo Shiniti Uchimura