Re: Comparing 2 Tables

[frank.alarcon]

Hi folks...

I´m wondering if it´s possible (and how) to do this...

Let´s assume we have two tables (A and B).
I want to SELECT data cells FROM each table WHERE the info contained in A.column 1 is contained in B.column 1'

ex:

Table A | Table B

apple | I like banana
orange | I like peach
lemon | I hate tomato
banana | Let´s buy an orange

% SELECT yadayadayada

Result :

banana | I like banana
orange | Let´s buy an orange

My drawback is to select data cells when a part of info desired is totally present in data cells from other tables.

Any help will be wellcome
rgds