December 17, 2004 at 12:51 pm
December 17, 2004 at 1:08 pm
not sure if you can count on the first 3 columns acting as keys, but something like this might work:
select sub.name,sub.lname, sub.mname,subAge.age,subPhone.phone,subLocation.location from
(select name,lname, mname from
group by name,lname)sub,
(select name,lname,Phone from
where phone is not null)subPhone,
(select name,lname, Age from
where age is not null)subAge
(select name,lname,Location from
where location is not null)subLocation
where (sub.name=subPhone.name and sub.lname=subPhone.lname)
and (sub.name=subAge.name and sub.lname=subAge.lname)
and (sub.name=subLocation.name and sub.lname=subLocation.lname)
..also note return of records on above example is where a record is found for all 3 data columns, joins could be changed to refelct different needs
December 17, 2004 at 2:13 pm
Look good. Thanks..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply