ambiguous column error when joining 2 tables which have the same column name

Question

in my table A {ID, FID, Name , Age}
in my table B{ID, Job}

When I use

SELECT ID // I want to get the ID of table B //**error**//
FROM A TA JOIN B TB
ON TA.ID = TB.FID
ORDER BY TA.Name;

Error: ambiguous column name ID

Is there anyway to do that without having to rename the column name? (The Worst scenario)
Thank you

Solution 1

SELECT TB.ID
FROM A TA JOIN B TB
ON TA.ID = TB.FID
ORDER BY TA.Name;

Use the full name (table name and column name seperated by a dot) to specifically select a column.

Your query doesn't fit your described table structure, I guess you swapped table A with table B.

Solution 2

SELECT TB.ID  ...

You need to prefix any ambiguous column anywhere with your table alias.