I have 2 tables, the table A with two columns, the primary key column named "MS", the other column named "Name", the table B has 2 columns, the primary key column named "MS", the other column named "Phone".
I can join two these tables using left join ... or simply "where" but all such ways also return a couple of column displaying the same value at the same record, that is A.MS and B.MS, that is not good to look, and especially, when I use "select *" from the joined table, it will show two those column unless I have to select each column I want like as "select A.MS, Name, Phone" from the joined table. (if using select *, it looks like "A.MS, Name, B.MS, Phone" as the order from left to right of the columns of the joined table). I have, in fact, many tables with many columns, and I want to join all them into an only table. If using "select *", simply but unexpectedly, the other way is too tedious to do because of the large number of tables to be joined! Is there any way to do it effortlessly?
Thank you so much!