+ 1

Can we select same column names from different tables like.

SELECT firstname FROM table1,table2,table3;

19th Dec 2019, 1:09 PM
Lakshmi Reddy Sanikommu
Lakshmi Reddy Sanikommu - avatar
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
19th Dec 2019, 1:18 PM
A͢J
A͢J - avatar
+ 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.
19th Dec 2019, 1:11 PM
A͢J
A͢J - avatar
+ 3
Ok bruh TQ a lot for helping
19th Dec 2019, 1:21 PM
Lakshmi Reddy Sanikommu
Lakshmi Reddy Sanikommu - avatar
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
19th Dec 2019, 1:15 PM
Lakshmi Reddy Sanikommu
Lakshmi Reddy Sanikommu - avatar