SQL Query Output to HTML

Objective:

Conclusion:

EXP_2	NAME_ID	PROJECTED	BORN	FATHER	MOTHER
William P. Gaffey 61 06/22/1955	William_Gaffey_1-10	William P. Gaffey	06/22/1955	William F Gaffey	Joanne Dunn
Virginia Gaffey 60 01/18/1957	Virginia_Gaffey_1-2	Virginia Gaffey	01/18/1957	William F Gaffey	Joanne Dunn
John Gaffey 58 09/26/1958	John_Gaffey_1-30	John Gaffey	09/26/1958	William F Gaffey	Joanne Dunn
Alan J. Gaffey 56 01/19/1961	Alan_Gaffey_1-40	Alan J. Gaffey	01/19/1961	William F Gaffey	Joanne Dunn
Jeffery Gaffey 53 05/01/1963	Jeffery_Gaffey_1-50	Jeffery Gaffey	05/01/1963	William F Gaffey	Joanne Dunn

Top

SELECT FAMFILEID(FM.FAM_ID), IIF(EMPTY( FM.PHOTO),'','<IMG SRC="'+ALLTRIM(FM.PHOTO)+'" height=100>')+'<br /> '+ ALLTRIM(FM.GIVEN)+IIF(!EMPTY(FM.DIED),AGE(FM.BORN,FM.DIED),' <span class="age" id="'+DTOS(FM.BORN)+'">'+AGE(FM.BORN,FM.DIED)+' </span>')+'<br /> '+ DTOC(FM.BORN)+IIF(!EMPTY(FM.DIED),' - '+DTOC(FM.DIED),' ') ,JUSTSTEM(FMFILE(FM.IND_ID)) Name_ID, THUMBNAIL(FMFILE(FM.IND_ID),FMFILE(FM.IND_ID),FM.GIVEN) Projected, THUMBNAIL( FM.PHOTO) Recorded, FM.BORN, ( SELECT THUMBNAIL(padr(FMFILE(FA.FATHER_ID) ,250,' '),FMFILE(FA.FATHER_ID) ,FA.FATHER) Father FROM FAMILY.DBF FA where FA.FAM_ID=FM.FAM_ID), ( SELECT THUMBNAIL(padr(FMFILE(FA2.MOTHER_ID),250,' '),FMFILE(FA2.MOTHER_ID) ,FA2.MOTHER) Mother FROM FAMILY.DBF FA2 where FA2.FAM_ID=FM.FAM_ID) FROM FAM_MEMBER.DBF FM where FM.FAM_ID=1

SOURCE
URL:	,
Organization:
Date Acquired:	Thursday January 19th, 2017 1:32 PM
Prepared By:	John Gaffey
Last Updated:	Thursday January 19th, 2017 1:32 PM

SQL Query Output to HTML

Gaffey_1