helloooow.
i have a little problem in mysql.
i have, lets say, 3 tables: table1, table2, table3
in each table i have a field called "name"
if i want to get all the different names from the 3 tables i am using the following query: "SELECT DISTINCT table1.name, table2.name, table3.name FROM table1, table2, table3"
but this gets me nothing while if i only put: "SELECT DISTINCT table1.name FROM table1" it gets me some results.
what am i doing wrong?
i have a little problem in mysql.
i have, lets say, 3 tables: table1, table2, table3
in each table i have a field called "name"
if i want to get all the different names from the 3 tables i am using the following query: "SELECT DISTINCT table1.name, table2.name, table3.name FROM table1, table2, table3"
but this gets me nothing while if i only put: "SELECT DISTINCT table1.name FROM table1" it gets me some results.
what am i doing wrong?