+ 1
Can we select same column names from different tables like.
SELECT firstname FROM table1,table2,table3;
4 Respuestas
+ 6
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
+ 3
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.
+ 3
Ok bruh TQ a lot for helping
0
SELECT table1.firstname,table2.firstname,table3.firstname FROM table1, table2,table3
Mean like this ??
I don't know whether it is right or wrong