Hi,
I have 2 tables on DB2 version 6

Tab_A
id name
1 shop1
2 shop2

Tab_B
id_tab_a keyword
1 book
1 bookstore
1 handbook
2 restaurant

I need to write a SQL query that find who have 'book' as keyword on Tab_B, but with no duplicated record. If i write:
Select distinct id, name left join Tab_B on id=id_tab_a where
keyword like '%book%'
obtain 3 duplicated records.
Any ideas?

Thanks,
Jhon