Can someone help me with the syntax of this SQL example using SQL Server files? I have three files members file, group registration file and group file. In my group file I have a field called leader that contains the group leaders memberflid. Is there any way in a single SQL statement to get the name of the leader also?

This works.

SELECT Classfl.descr as class, Grpfl.descr as group, Memberfl.fname, Grpfl.leader ;
 FROM  ims!classfl ;
 	INNER JOIN ims!classregfl;
    INNER JOIN ims!memberfl;
    INNER JOIN ims!grpregfl;
    INNER JOIN ims!grpfl ;   
   ON  Grpfl.grpflid = Grpregfl.grpflid ;
   ON  Memberfl.memberflid = Grpregfl.memberflid ;
   ON  Memberfl.memberflid = Classregfl.memberflid ;
   ON  Classfl.classflid = Classregfl.classflid;
 WHERE Classfl.classflid = 3;
 ORDER BY Classfl.descr, Grpfl.descr, Memberfl.fname

This does not work, can you make it work?

SELECT Classfl.descr as class, Grpfl.descr as group, Memberfl.fname, Grpfl.leader, (sele fname FROM memberfl where memberid = grpfl.leader) as LeaderName ;
 FROM  ims!classfl ;
 	INNER JOIN ims!classregfl;
    INNER JOIN ims!memberfl;
    INNER JOIN ims!grpregfl;
    INNER JOIN ims!grpfl ;   
   ON  Grpfl.grpflid = Grpregfl.grpflid ;
   ON  Memberfl.memberflid = Grpregfl.memberflid ;
   ON  Memberfl.memberflid = Classregfl.memberflid ;
   ON  Classfl.classflid = Classregfl.classflid;
 WHERE Classfl.classflid = 3;
 ORDER BY Classfl.descr, Grpfl.descr, Memberfl.fname