Yet another question, and an example of my code.
i have pulled some of the information that i need for the flat file by connecting to 3 tables, then sending the information i have chosen from the table into columns.
i need to connect to another 2set of tables to add further information to my first record. how can i do a select statement within a select statement; example below;
Thank you for your help, just to make sure i am in the right track could you just please see if i go the right idea.
my code so far for the flat file is set as such;
set echo off;
column version format a4;
column description format a5;
column relationship format a2;
column ssn1 format a11;
column ssn2 format a11;
column lastname format a26;
column firstname format a26;
SELECT a.relat_id relationship, a.ssn_id ssn1,
a.ssn_id ssn2, b.last_name lastname,
from Tbl1 a, Tbl2 b, Tbl3 c
where a.empl_id = b.empl_id
and b.empl_id = c.empl_id
and c.empl_id = a.empl_id.
this will produce something like this;
wife 123456789 123456789 lastname firstname
after first name i need to pull another set of information from another select statement how can i add the new select staement to what i already have above so it can pull the info right after first name.