Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Question Unanswered: Oracle Form join with Substr

    Dear all,

    how is it possible to join 2 tables in Oracle Form based on their substring value?

    Here is what I Have in the

    delvno = 'WA0192001'
    batchno = 'A0192001'

    select B.batchno from del.deliver1 A, tma21 B WHERE SUBSTR(A.delvno,2,3) = SUBSTR(B.batchno,1,3).

    I want to join them with the A01 key.

    Thanks a ton and in advance.

    Last edited by gokou777; 09-12-03 at 15:59.

  2. #2
    Join Date
    Sep 2003

    Re: Oracle Form join with Substr

    Firstly join the 2 blocks based on column names...
    Then go and edit the block level triggers that Forms creates for the relation ship....

    Change the where clause there to your SUBSTR one ...

Posting Permissions

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