Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    119

    Unanswered: What is LEFT OUTER JOIN in Pervasive SQL?

    I'm not very familiar w/ Pervasive SQL syntax. The SELECT query runs on MS SQL but syntax error in Pervasive SQL.

    Here's my query in MS SQL
    SELECT CustomerTable.CustID, CustomerTable.CustName, ProductTable.ProdID
    FROM CustomerTable LEFT OUTER JOIN ProductTable ON CustomerTable.ProdID=ProductTable.ProdID
    I use LEFT OUTER JOIN because all data on CustomerTable should be displayed even if ProdID is null in value.

    What's the equivalent syntax of LEFT OUTER JOIN in pervasive SQL? The query below runs on Pervasive SQL but I cannot do this query because it means INNER JOIN.

    SELECT CustomerTable.CustID, CustomerTable.CustName, ProductTable.ProdID
    FROM CustomerTable
    WHERE CustomerTable.ProdID=ProductTable.ProdID

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    What version of PSQL are you using?
    Here's a link to the v9.5 JOIN syntax:
    http://www.pervasive.com/library/doc...ref-04-53.html
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Oct 2005
    Posts
    119
    thanks mirtheil :-)

Posting Permissions

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