Re: usage of "distinct" in a table join query?

2001-02-05 Thread Rus
Have you try GROUP BY? - Original Message - From: Marc Swanson <[EMAIL PROTECTED]> To: mysql list <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 9:32 AM Subject: usage of "distinct" in a table join query? > Hello, > > I am trying to craft a query

usage of "distinct" in a table join query?

2001-02-04 Thread Marc Swanson
Hello, I am trying to craft a query that will allow me to retrieve truly unique result elements. Here's my setup: table_1 link_field varchar(20) field1 varchar(20) field2 varchar(20) table_2 -- link_field varchar(20) field3 varchar(20) Here's what