Distinct select on 2 tables

[clemrock]

Hello,

I'm trying to do a select distinct data from from 2 tables and the solution I'm having almost works but it's still pulling multiple records from both tables.

Here's the Select statement I'm trying:

SELECT DISTINCT table_1.table_1_id, table_1.title, table_2.field_1 FROM project, conversation WHERE table_1.table_1_id = table_2.table_2_id

Thanks for any time you have.

Clem C

 

[r937]

with DISTINCT, you are guaranteed to get distinct results

when you say "it's still pulling multiple records from both tables" do you mean you only want one result from each table?



r937.com | rudy.ca