Can we select same column names from different tables like.

Question

SELECT firstname FROM table1,table2,table3;

Answer 1

lucky Yes you can call with table name also but this is not best solution Because your script may go too long and it will become lengthy so better to use aliases like this.

SELECT

t1.firstname, t2.firstname, t3.firstname

FROM
table1 t1, table2 t2, table3 t3

Answer 2

Yes you can select but it will give you some error Because sql will confused so better to make aliases of table then select column using that aliases.

For example if you are calling same person from two groups so both person will confused to whom you are calling.

Answer 3

Ok bruh TQ a lot for helping

Answer 4

SELECT table1.firstname,table2.firstname,table3.firstname FROM table1, table2,table3

Mean like this ??
I don't know whether it is right or wrong