fi
New Member
LastLegionary said:This is what I'm talking about:
Code:select distinct a.target, b.region, b.country from typeEntries a, locations b where a.origination = (select distinct a.origination from typeEntries a, locations b where a.origination = b.Location and a.r_type = (select distinct a.r_type from services a, types b where a.r_type = b.r_type and a.masterlistID = (select masterlistID from masterlists where DisplaySequence = (select min(DisplaySequence) from masterlists)) and a.siServiceTypeId = (select siServiceTypeId from services where DisplaySequence = (select min(DisplaySequence) from services) and masterlistID = (select masterlistID from masterlists where DisplaySequence = (select min(DisplaySequence) from masterlists))) and a.DisplaySequence = (select min(DisplaySequence) from types where masterlistID = (select masterlistID from masterlists where DisplaySequence = (select min(DisplaySequence) from masterlists))))) and a.r_type = ((select distinct a.r_type from services a, types b where a.r_type = b.r_type and a.masterlistID = (select masterlistID from masterlists where DisplaySequence = (select min(DisplaySequence) from masterlists)) and a.siServiceTypeId = (select siServiceTypeId from services where DisplaySequence = (select min(DisplaySequence) from services) and masterlistID = (select masterlistID from masterlists where DisplaySequence = (select min(DisplaySequence) from masterlists))) and a.DisplaySequence = (select min(DisplaySequence) from types where masterlistID = (select masterlistID from masterlists where DisplaySequence = (select min(DisplaySequence) from masterlists))))) and a.target = b.Location order by country, region
As Mr Beeblebrox once said...
OW! My brains!!