AnsweredAssumed Answered

NSQL Queries Help

Question asked by lchung on Oct 21, 2009
Latest reply on Oct 30, 2009 by lchung
Hi,  appreciate if someone can advice about NSQL queries:  A.   in Select statement below,         1.   is FIN a table name?   for table fin_financials         2.   is F.ID is the field ID, right?   SELECT     @SELECT:DIM:USER_DEF:IMPLIED:FIN:F.ID:ID@,                  @SELECT:DIM_PROP:USER_DEF:IMPLIED:FIN:isnull(F.ITCFR,0):ITCFR@,                  @SELECT:DIM_PROP:USER_DEF:IMPLIED:FIN:isnull(F.ITCFR,0):ITCFR1@,                  @SELECT:DIM_PROP:USER_DEF:IMPLIED:FIN:isnull(F.DASHREP,0):DASHREP@,                  @SELECT:DIM_PROP:USER_DEF:IMPLIED:FIN:isnull(F.DASHREP,0):DASHREP1@,                 @SELECT:DIM_PROP:USER_DEF:IMPLIED:FIN:F.ACTIVE:ACTIVE@,      B.   If there are more than one tables, do I have to create another Select statement beginning - SELECT   @SELECT:DIM:USER_DEF:IMPLIED......?  thank you!Lily