Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MySQL getting distinct data from multiple columns?
Its okay thanks for having a look at this. I think I've sussed it. Vaastav -
MySQL getting distinct data from multiple columns?
+---------+---------+ | column1 | column2 | +---------+---------+ | NULL | NULL | | NULL | 0 | | NULL | 1 | | 0 | NULL | | 0 | 0 | | 1 | 1 | | 1 | NULL | | 0 | 0 | +---------+---------+ The data in the table can... -
MySQL getting distinct data from multiple columns?
Hi, I have got 4 columns with data in and I want select all the distinct data from each column and display it in a table. How do I go about doing this. Heres an exmaple of what my Columns in my table are like:- Column1 Column2 0 this is empty this is empty 1 0... -
Simple SQL Query Problem?
Hi how do I embed a variable in a sql statement in a Java bean. I am trying reference a vaule from my jsp which is stored in the variable argshowcourse in my java bean. Is this the right way to do it? String sqlQuery = "SELECT * from modules WHERE 'argShowCourse' = 'O'; -
Retrieving Data from two tables?
Hi, I've got a table with univeristy Modules with the following fields. Stack Module Code Module Title Credits Status Example data '1', 'INFO3420', 'Professional IT', '15', 'Mandatory'. I also have a table with Course Details CourseCode and CourseTitle Example data 'CS', 'Computer Science'...
