I need a push with the 'select distinct' command. My brain just isn't following along!
I want to select all rows in my view (dependant on my 'where' clause), but I only want one instance of each Company to show. Is there a way to use Select * from... yet still use 'distinct' or do I need to select (and list) each column ? thanks, Lin
