How to join same table having same Name and data everything is same how to join in SQL?

Question

How to join same two tables

Answer 1

select * from t, t;

You need to explain more, to get a meaningful response. What kind of data is in the table and which key you want to connect it to itself?
A typical case of self join, is a table of employees, where every employee has also a manager, so manager_id points to employee_id of the same table.

Answer 2

How to join two similar tables that it?

Answer 3

You are not adding any new information, just repeated your own question. Maybe try some reading.
https://www.w3resource.com/sql/joins/perform-a-self-join.php

Answer 4

Two same table cannot join

Answer 5

It's against codds rules

Answer 6

Understand