SELECT DISTINCT with multiple tables?

[viveleroi0]

I have an error log that shows errors not yet seen - but I want to only display DISTINCT results. This works fine when I am only pulling data from one MySQL table.

I have three fields that I need to compare.

Table1.error_view
Table2.error_date
&
Table2.error_IP

BUT- I want the query to pull DISTINCT results for the error_IP field, while allowing duplicate results in the other fields.

SELECT * FROM Table1, Table2 WHERE Table1.error_view < Table2.error_date

how can I do this?

[Stressed]

Did you try something like.

SELECT DISTINCT(Table2.error_ip), Table1.error_view, Table2.error_date FROM Table1, Table2 WHERE .....

Something like that maybe?

[Roger_Ramjet]

Not possible. Not sure what you are after but if you read the MySQL manual http://dev.mysql.com/doc/mysql/en/DISTINCT_optimization.html you will see why.

What you are probably after is GROUP BY anyway.