join

From: itd: Joerg Leute <jl_at_itdesign.de>
Date: Sat, 30 Oct 1999 20:09:36 +0200
Message-ID: <7vfc7g$b1o$1@news01.btx.dtag.de>

Hi everybody

Suppose i have two tables

Table1:

ID        Name
1        Joe

Table2:

Table1_ID LastName

1                    Jackson

The normal join results in

ID     Name    Lastname
1       Joe        Jackson

Is there any way to have a result like this....

ID        Name    Lastname
1        Joe
1        Joe        Jackson

...withoug using a UNION query. This example is very simplified - the real query takes about 40 seconds - a UNION would last too long.

Thanks for your help

Joerg Received on Sat Oct 30 1999 - 13:09:36 CDT