How to join two tables permanently with SQL?

Question

Is it possible to join two tables permanently? Where I am just going to execute once that query and then after that it can be already joined automatically even if I exit DBMS?

Answer 1

You may want to look into creating a view.

A view is essentially a stored SQL statement that you can query like you would a table.

create view MyView as
    select TableA.Field1, TableB.Field2
    from TableA
    join TableB on TableB.ID = TableA.ID


select *
from MyView