Hello everyone. Is there no way of changing the ID column of the tables that have been joined using UNION to be unique

Question

What I mean here is, instead of having 1,2,3,1,2,3 as the ID of the resulting table, you convert it to 1,2,3,4,5,6 and so on.....using a line of code.

Answer 1

SELECT DISTINCT id
FROM table1, table2
WHERE condition
ORDER BY id ASC;

Answer 2

Any more ways I can do this pls?

Answer 3

INSERT INTO Employees (ID, FirstName, LastName)
VALUES (5, 'john', 'philip');
please try this syntax

Answer 4

This will give you a new row