My SQL Join table duplicate problems

[scifind]

Tweet

Hi
I am joining 2 tables using an expression like:

select tbl1.a, tbl1.b, tbl1.c, tbl2.a, tbl2.e FROM tbl1, tbl2WHERE tbl1.a = tbl2.a AND tbl1.b = VALUE 

Due to the nature of the data I am getting duplicate rows.
Is there a quick SQL method to remove duplicate rows?
Do I put distinct() round each of the columns?

Cheers

[stooz]

I think a distinct around the tbl1a select statement will probably do it.

select distinct(tbl1.a), tbl1.b, tbl1.c, tbl2.a, tbl2.e FROM tbl1, tbl2 WHERE tbl1.a = tbl2.a AND tbl1.b = VALUE

[scifind]

Cheers. That appears to work.