Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    6

    Unanswered: Can you use inner joins in Oracle select statement?

    This is the statement I am using and I get 'SQL command not ended properly error'

    "SELECT DISTINCT ct.CASENUM, ct.TOSERVICEDATE, ct.SUBMITTEDAMOUNT, ct.CHECKDATE, ct.CHECKNUM FROM CLAIMTRAN ct INNER JOIN CLAIMTRANH ch ON ct.CASENUM = ch.CASENUM WHERE ct.TOSERVICEDATE = to_date('" & Me.txtDateofService.Text & "','dd/mm/yyyy') AND ch.PATIENTREF = '" & Me.txtAccountNo.Text & "'"



    This is what I have as my code before it fills in the variables in debug mode. What am I doing incorrectly?

  2. #2
    Join Date
    Dec 2003
    Posts
    1,074
    Looks ok to me, & yes, ANSI 92 join syntax is supported. What string do you finally end up with, after the values are inserted.

    Maybe you still need a semi-colon at the end? That's the only thing I can think of

    Code:
    ...Me.txtAccountNo.Text & "';"

Posting Permissions

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