SQL SELECT Cartisian Problem

From: Richard Murphy <rmurphy_at_lbpc.com>
Date: Thu, 22 Apr 1999 17:26:22 GMT
Message-ID: <371F5C78.5B60A38A@lbpc.com>

I am trying to link link one main table to two child tables that have no link between them. Trying to figure away to prevent a Cartesian product of the tables. For example if I want the results to be:

Name    Dogs     Cats
------    -----      ----
John      dog1      cat1
             dog2      cat2
             dog3

How could i do this if the owner, dogs, and cats are all in separate tables and i don't know how many of each pet there are. I do not want to use a union with blank spaces, and i do not want to get 6 rows back.

Thanks, R. Received on Thu Apr 22 1999 - 12:26:22 CDT