Re: ISO: sql technique to select information from more than one table
From: Larry W. Virden <lvirden_at_gmail.com>
Date: Tue, 10 Mar 2009 09:54:16 -0700 (PDT)
Message-ID: <8733b241-8e45-4071-a80e-5a76f5c90780_at_v15g2000yqn.googlegroups.com>
On Mar 10, 12:48 pm, "Larry W. Virden" <lvir..._at_gmail.com> wrote:
> Ah - removing the blank line before the ; now actually causes the
> select to execute. However, what I get is two lines - the first column
> of the first line says "csi_security" followed by the csi_hr name and
> then the csi_security name. Then, 1348 lines later, there is a second
> line which says "csi_telecom" in the first column, followed by the
> csi_hr name and then the csi_telecom name.
Date: Tue, 10 Mar 2009 09:54:16 -0700 (PDT)
Message-ID: <8733b241-8e45-4071-a80e-5a76f5c90780_at_v15g2000yqn.googlegroups.com>
On Mar 10, 12:48 pm, "Larry W. Virden" <lvir..._at_gmail.com> wrote:
>
> Ah - removing the blank line before the ; now actually causes the
> select to execute. However, what I get is two lines - the first column
> of the first line says "csi_security" followed by the csi_hr name and
> then the csi_security name. Then, 1348 lines later, there is a second
> line which says "csi_telecom" in the first column, followed by the
> csi_hr name and then the csi_telecom name.
Let me clarify. I get 1700+ lines output. The first 1349 lines are the results relating to csi_security. The last 356 lines are tagged as being from the csi_telecom table. Received on Tue Mar 10 2009 - 11:54:16 CDT