Example #1 (general-summary-database-query-citrix.txt) will pull in ALL columns from LU_Appname and SDB_APPHISTORY, with PK_AppnameID and FK_APPNAMEID as part of the inner join.

Sql Query (query is also attached to this page for download):

SELECT     SDB_APPHISTORY.ENDTIME, LU_APPNAME.PK_APPNAMEID, LU_APPNAME.APPNAME, LU_APPNAME.APPTYPE,
                      SDB_APPHISTORY.PK_SDB_APPHISTID, SDB_APPHISTORY.FK_APPNAMEID, SDB_APPHISTORY.FK_SERVERID, SDB_APPHISTORY.STARTTIME,
                      SDB_APPHISTORY.ENDTIME AS Expr1, SDB_APPHISTORY.SERVERUTCBIAS
FROM         LU_APPNAME INNER JOIN
                      SDB_APPHISTORY ON LU_APPNAME.PK_APPNAMEID = SDB_APPHISTORY.FK_APPNAMEID