Re: discoverer 3.08 how to join 2 tables in a NxN relation

Hi Joseba:

I will suggest you to create a view to be used by Discoverer. Joins in Discoverer could be very slow.

Regards,

Mabel

Joseba Real de Asua <frelance_at_sarenet.es> wrote in article <364480CC.C81E83AD_at_sarenet.es>...
> I am a newbie with Discoverer. I will like to join two tables:
>
> Table A has N records
>
> Table B has M records
>
> The key of both tables is the same but table A can has records that are
> not in Table B and Table B can has records that are not in Table A.
>
> I want a result with ALL the records from Table A and Table B.
>
> Each table has around 300.000 records
>
> Please, i do not have usual access to this newsgroup, so if you can
> reply me by e-mail to:
>
> frelance_at_sarenet.es
>
> I solved it partially but it takes more than 30 minutes to obtain the
> result.
>
> may you help me?
>
> Claudia De Azua
> frelance_at_sarenet.es
>
>
>
>
Received on Mon Nov 09 1998 - 20:11:05 CET