LINK 2 TABLE ON JQL?

Start
Prev
1
Next
End

thanhcon91
Topic Author
Offline
New Member

9 years 2 months ago - 9 years 2 months ago #17977 by thanhcon91

LINK 2 TABLE ON JQL? was created by thanhcon91

HEY GUYS,
I HAVE 2 TABLES, CUSTOMER AND ACCOUNT. @ID ON CUSTOMER = AC.CUSTOMER ON ACCOUNT. HOW CAN I GET 10 RECORDS CUSTOMER AND SHOW INFOMATION ACCOUNT? PLEASE HELP ME!

Last edit: 9 years 2 months ago by thanhcon91.

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired

9 years 2 months ago #17980 by jpb

Replied by jpb on topic LINK 2 TABLE ON JQL?

You can write a routine that receives the customer number and returns the needed information from all existing accounts as a multivalued list in first parameter, e.g.

SUBROUTINE YOUR-ROUTINE-NAME(RETURNED.LIST,CUSTOMER.ID)
$INSERT ...
<fill into RETURNED.LIST whatever you want to see>

This subroutine can be called in JQL using EVAL"@ID;SUBR('YOUR-ROUTINE-NAME',@1)"

Please Log in or Create an account to join the conversation.

A.bishlawy
Offline
New Member

9 years 2 months ago #17982 by A.bishlawy

Replied by A.bishlawy on topic LINK 2 TABLE ON JQL?

RUN THE FOLLOWING SCRIPT FROM DBTools sql

SELECT * FROM (SELECT C.RECID "CUSTOMER ID",C.MNEMONIC "CUSTOMER MNEMONIC",C.SHORT_NAME "CUSTOMER SHRT NAME",
A.RECID , A.ACCOUNT_TITLE_1 FROM TAFJV_FBNK_CUSTOMER C
LEFT OUTER JOIN TAFJV_FBNK_ACCOUNT A ON C.RECID = A.CUSTOMER)
WHERE rownum <= 10

Please Log in or Create an account to join the conversation.

armin
Offline
Elite Member
“So long - and thanks for all the fish!”

9 years 2 months ago #17985 by armin

Replied by armin on topic LINK 2 TABLE ON JQL?

@bishlawy :
Strange JQL - ever heard of installations on pure jBase?
One might also use SQLSELECT if he knows the syntax and has the correct version of TAFC.

using R11 on Unix

The following user(s) said Thank You: jpb

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Time to create page: 0.067 seconds