Re: table alias in Select FROM List with :$tables ?

["PHUNG, BINH" <BPHUNG@FINEHOST.COM>]

I don't see what is the point of this. Is it faster to do it this way? is
there  a benefit to this method as opposes to the normal method?

> -----Original Message-----
> From: Manoj Gurjar [SMTP:mgurjar@HOTMAIL.COM]
> Sent: Wednesday, November 03, 1999 9:22 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: table alias in Select FROM List with :$tables ?
>
> Hi Binh,
>
> As someone alreadt explained before,
>
> FROM [PS_JRNL_HEADER JH, PS_JRNL_LN JL:$HEADER_AND_LINE_REC]
>
> Here JH, and JL aliases are used to help compile your
> select statement, I mean to tell compiler that whatever
> fields you selected in Select are of type in JH and JL table,
> while tables list in $HEADER_AND_LINE_REC are the
> actually table it should use to retrive rows.
>
> Do display for $HEADER_AND_LINE_REC and u will see the
> name of the actaul tables going to be used in Select, from
> where rows are selected.
>
> HTH,
> Manoj
>
>
>
>
> >From: "PHUNG, BINH" <BPHUNG@FINEHOST.COM>
> >Reply-To: SQR-USERS@list.iex.net
> >To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
> >Subject: alias?
> >Date: Tue, 2 Nov 1999 08:59:23 -0500
> >
> >Hello to everyone, New to this group thing.
> >Hope someone can help explain to me what is the purpose of line 14.
> >What is the point or idea behind having ":$HEADER_AND_LINE_REC" after the
> >alias "JL"
> >I just want to know what or how will it affect the program.
> >
> >Thank You in Advance.
> >Binh
> >
> >
> >1)  let $Header_Rec = $Ledger_Rec_Header || ' JH'
> >2)  let $Line_Rec   = $Ledger_Rec_Line || ' JL'
> >3)  let $Header_and_Line_Rec = $Header_Rec || ', ' || $Line_Rec
> >
> >4)begin-SELECT  ON-ERROR=SQL-Error
> >
> >5)JL.JOURNAL_DATE
> >6)JL.JOURNAL_ID
> >7)JL.UNPOST_SEQ
> >8)JL.JOURNAL_LINE
> >9)JL.CURRENCY_CD
> >10)JL.FOREIGN_CURRENCY
> >11)JL.FOREIGN_AMOUNT
> >12)JL.MONETARY_AMOUNT
> >13)JL.MOVEMENT_FLAG
> >
> >14)FROM [PS_JRNL_HEADER JH, PS_JRNL_LN JL:$HEADER_AND_LINE_REC]
> >15)WHERE JL.BUSINESS_UNIT = JH.BUSINESS_UNIT
> >16)  AND JL.JOURNAL_ID    = JH.JOURNAL_ID
> >17)  AND JL.JOURNAL_DATE  = JH.JOURNAL_DATE
> >18)  AND JL.UNPOST_SEQ    = JH.UNPOST_SEQ
> >
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com