Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FROM clause
Message
From
25/02/2002 14:36:02
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
FROM clause
Miscellaneous
Thread ID:
00624712
Message ID:
00624712
Views:
55
The following SQL statement is working fine. I just want to understand what does 'oj' means. It is located right after the FROM clause.

Here is the select statement:
SELECT
    a."Project", a."Invoice_Nbr", a."Invoice_date", a."Debit_total_Acct_Curr", 
    a."Credit_Total_Acct_Curr", a."Invoice_or_cash_receipt_date", 
    a."Credit_Amount_Acct_Curr", a."Account_Currency", a."Project_Alpha_Name", a."Document_type",
    b."resp_type_code",
    MyCurrencyRates."currency_rate",
    emp_info."emp_name",
    prj_bill."org_code_resp"
FROM
    { oj ((("ProdDB"."dbo"."view_CashReceiptReport" a INNER JOIN "ProdDB"."dbo"."MyCurrencyRates" MyCurrencyRates ON
        a."Account_Currency" = MyCurrencyRates."currency_code")
     INNER JOIN "ProdDB"."dbo"."prj_emp_resp_listing" b ON
        a."Project" = b."prj_code")
     INNER JOIN "ProdDB"."dbo"."prj_bill" prj_bill ON
        b."prj_code" = prj_bill."prj_code")
     INNER JOIN "ProdDB"."dbo"."emp_info" emp_info ON
        b."emp_code_resp" = emp_info."emp_code"}
WHERE
    a."Invoice_or_cash_receipt_date" >= {ts '2002-02-25 00:00:00.00'} AND
    b."resp_type_code" = 'PM' AND
    a."Document_type" = 'R'
Thanks,
Sergio
Next
Reply
Map
View

Click here to load this message in the networking platform