[SQL] How to union table without union statement?

2007-02-28 Thread calendarw
ction speed? Thanks. -- Jr. P calendarw

Re: [SQL] How to union table without union statement?

2007-02-28 Thread calendarw
FROM i_alarmtbl, alarmdtl WHERE i_alarmtbl.tagname::text = alarmdtl.tagname::text ORDER BY 1; On 2/28/07, Hiltibidal, Robert <[EMAIL PROTECTED]> wrote: Can you provide a schema? -- *From:* [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *On Behalf Of *calendarw

Re: [SQL] How to union table without union statement?

2007-03-06 Thread calendarw
? Have you considered other structure options like partitioning? Is there a real need to have these tables separate? or could you have them all in one table with an column to identify the source of the log entry? -- Jr. P calendarw