index my_id (id);
-leo-
- Original Message -
From: Steffan A. Cline
To: Leo ; [EMAIL PROTECTED]
Sent: Monday, November 10, 2003 8:12 PM
Subject: Re: Complex query woes
Leo,
Thanks for the quick reply. There was a typo but I fixed it. Below is
what I used after
To: "Steffan A. Cline" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> Subject: Re: Complex query woes
>
> have you try left join?
>
> select
> mgr.company,
> building.bldgname,
> tenant.id
> from
> customers mgr
> left join customers building on buildin
hopefully it work :)
-leo-
- Original Message -
From: Steffan A. Cline
To: [EMAIL PROTECTED]
Sent: Monday, November 10, 2003 12:56 PM
Subject: Complex query woes
Basically I have a table that contains 3 types of records. Property
managers, buildings and tenants. They are
I am hoping someone here might have an idea how to set up a complex query I
have been trying to figure out.
Basically I have a table that contains 3 types of records. Property
managers, buildings and tenants. They are related upon insert by an ID and a
PID (parent id). For example :
ID PID C
