Are the columns in the same or different tables? What is the key of the table or tables? Are you doing a GROUP BY? If so, on what columns? If you can give an example of something that does not work, it might provide a clearer idea of what you are trying to do.