Get auto increment id of two linked tables (INNER JOIN)

Question

Get auto increment id of two linked tables (INNER JOIN)

Navigation

#1 by (1 votes)

-1

Let's see if I can explain at first ...

I have two tables [topics] and [notification]

I joined these tables with INNER JOIN to get the data of both, so far so good ...

But when I need to select the [id] from the [notification] table in the while, but only returns the [id] of the table [topics], how can I retrieve the id of both in that select?

Here's my SELECT:

SELECT notification.*, topicos.* FROM notification INNER JOIN topicos ON notification.user = "USUARIO_TAL"

id

asked by anonymous 18.08.2018 / 03:17

1 answer

Doubt about functions in php Telnet server in python that changes the title of the PuTTY window

score 1 · Accepted Answer

Ideally, you should list the columns that interest one by one, instead of using * . Then you can set an alias for each one if necessary. For example:

SELECT
    notification.id AS notification_id,
    topicos.id AS topico_id
...

In your while (in php, from what you said), you can refer to the id by alias, in the case notification_id or topico_id .