52
Hello everyone. I am trying to create an innerjoin with the same table. Can anybody kindly suggest how should I proceed? I already created two buffers for that table. Do I need to create a relation on the same table through RecId?
*This post is locked for comments
I have the same question (0)
Hi HiteshAX,
If you talking about select statement then you can do something like:
CustTable custTableA, custTableB; select custTableA join custTableB where custTableA.AccountNum == custTableB.AccountNum;
If you want to use them as 2 datasources on a form you can either add relation on a table level or manually add it to the form query on init method of the form.
Share
Report
All responses (
Answers (
