Re: [SQL] Selecting * from the base table but getting the inheriteds

2002-11-01 Thread Ross J. Reedstrom
On Wed, Oct 30, 2002 at 10:25:17AM +0100, James Adams wrote: Yea it would be easier to have everything in one table filling unused with nulls, but I was trying to avoid that because of the wasted space. But I think I'll do it that way after all :~] Thanks for your help Don't fret too

Re: [SQL] Selecting * from the base table but getting the inheriteds

2002-10-30 Thread Tomasz Myrta
Uz.ytkownik James Adams napisa?: Hello, I have a baseTable. I have a number of decendantTables that INHERIT from the base table. I want to do somthing like =select * from baseTable; But I want it to return the data in the all the descendant tables along with the extra column that they

Re: [SQL] Selecting * from the base table but getting the inheriteds

2002-10-30 Thread James Adams
Yea it would be easier to have everything in one table filling unused with nulls, but I was trying to avoid that because of the wasted space. But I think I'll do it that way after all :~] Thanks for your help - Original Message - From: Tomasz Myrta [EMAIL PROTECTED] To: James Adams

[SQL] Selecting * from the base table but getting the inheriteds columns

2002-10-29 Thread James Adams
Hello, I have a "baseTable". I have anumber ofdecendantTables thatINHERIT from the base table. I want to do somthing like =select * from baseTable; But I want it to return the data in the all the descendant tables along with the extra column that they contain. How do I do this? please