Quick duplicate question

[teknikalbody]

Hi experts,

Just a quicky, I am doing...

Select field_1, field_2
from table_A a, table_B b
where a.identity = b.identity;

However, table_B has duplicates but I just want the one record from the table because they are exactly the same so the fist one it comes across will do.
Any suggestions ?

TIA

 

[hoinz]

Select distinct field_1, field_2

 

[teknikalbody]

Thanks,

Tried that but unfortunately I can't use distinct because my field_2 is a blob.

 

[sem]

Do both field_1, field_2 belong to the same table?

Regards, Dima

http://seminihin.narod.ru

 

[teknikalbody]

yes

 

[sem]

I suppose that they belong to table_A:

Select field_1, field_2
from table_A a
where exists (select 1 from table_B b
where a.identity = b.identity);

Regards, Dima

http://seminihin.narod.ru

 

[teknikalbody]

sorry no, the duplicates are on table_B which also contains the image field i need to extract.

 

[sem]

So which record from table_b you need to extract when more then 1 exist???

Regards, Dima

http://seminihin.narod.ru

 

[teknikalbody]

just as long ive got only got one record from each match I dont mind which one of the duplicates is extracted.

So I was thinking along the lines of max(b.rowid)...