Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Location
    Montreal, Canada
    Posts
    6

    Question Unanswered: What is this symbol : (+) ??

    I am trying to understand this query but it can't find what the (+) is meaning.

    Can you help me ?

    select *
    from demande_credit_asap d,
    pret_debourse_osv p
    where d.produitlog = :bien_code
    and d.nomarchandlog = :march_no
    and (trunc(d.dateouverturelog) >= to_date('1/1/2001','MM/DD/YYYY') and
    trunc(d.dateouverturelog) <= to_date('5/7/2002','MM/DD/YYYY'))
    and d.noasaplog = p.noasapdebourse (+)

  2. #2
    Join Date
    May 2002
    Location
    KOLKATA, INDIA
    Posts
    7
    select *
    from demande_credit_asap d,
    pret_debourse_osv p
    where d.produitlog = :bien_code
    and d.nomarchandlog = :march_no
    and (trunc(d.dateouverturelog) >= to_date('1/1/2001','MM/DD/YYYY') and
    trunc(d.dateouverturelog) <= to_date('5/7/2002','MM/DD/YYYY'))
    and d.noasaplog = p.noasapdebourse (+)


    This means that even if there is no data in pret_debourse_osv corresponding to the record in demande_credit_asap, it should display the data from demande_credit_asap table.
    This is called outer join.
    So these query will display all the records from the two tables meeting all the criteria and also display all records from d which are qualifying the criteria specified and not matching with the records in table p.

    Santosh Sarkar

  3. #3
    Join Date
    Jun 2002
    Location
    Montreal, Canada
    Posts
    6
    Thank you very much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •