Select Distinct from one table
Posted on 2003-12-01
This should be farily easy but I just can't seem to get it. I am tracking 404 errors on a web site in a table and reidrecting the user if the URL they are trying to reach exists in another table. What I want to do basically is create a view that looks at the column in the table with the error log that contains the URL that users have tried to reach and compare that to the column in the table that contains redirct urls. If the url in the log table does not appear in the table of redirects, I want all of the columns of data from that record in the log table to appear in the view. I don't know if I'm making any sense or not. Any help is greatly appreciated.