Our training courses

Other training resources

Our training venues

Why we are different

Details for derloopkat

derloopkat has participated in the following threads:

Added by derloopkat on 10 Jun 2024 at 14:40

SELECT child.FamilyName, IIF(grand_parent.FamilyID is not null, concat(grand_parent.FamilyName, ' > ', parent.FamilyName, ' > ', child.FamilyName)

, IIF(parent.FamilyID is not null, concat(parent.FamilyName, ' > ', child.FamilyName), '')) as FamilyPath

FROM tblFamily child

LEFT JOIN tblFamily parent ON child.ParentFamilyId=parent.FamilyID

LEFT JOIN tblFamily grand_parent ON parent.ParentFamilyId=grand_parent.FamilyID

ORDER BY FamilyName

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...