Change column name "id" of an sql return

Question

I want to conduct a consultation SQL and change the name of the columns in the result because I have 3 columns id.

Currently my SQL this way:

SELECT * 
FROM shopweb_tipo as st 
INNER JOIN shopweb_categoria AS sc 
INNER JOIN shopweb AS s 
WHERE s.categoria = sc.id 
    AND s.tipo = st.id

I tried to do so but I could not result.

SELECT * 
FROM shopweb_tipo as st 
INNER JOIN shopweb_categoria AS sc 
INNER JOIN shopweb AS s 
WHERE s.categoria = sc.id 
    AND s.tipo = st.id 
    AND shopweb.id as "id_shopweb"

Answer 1

You have to describe the columns instead of putting the * and give an alias for them example:

SELECT
    st.id AS [apelido para o id],
    [demais_campos st],
    sc.id AS [apelido para o id],
    [demais_campos sc],
    s.id AS [apelido para o id],
    [demais_campos s]
FROM
    shopweb_tipo AS st
INNER JOIN shopweb_categoria AS sc
INNER JOIN shopweb AS s
WHERE
    s.categoria = sc.id
AND s.tipo = st.id

Sure, and call the other fields in the query also.

Another way is to search only the id field and then the other fields, but the ID field will come twice, one with alias other

SELECT
    st.id AS [apelido para o id],
    st.*,
    sc.id AS [apelido para o id],
    sc.*,
    s.id AS [apelido para o id],
    s.*
FROM
    shopweb_tipo AS st
INNER JOIN shopweb_categoria AS sc
INNER JOIN shopweb AS s
WHERE
    s.categoria = sc.id
AND s.tipo = st.id