topic Re: query sql in Application Development and Automation Discussions

query sql

Former Member — Tue, 10 Dec 2019 09:15:50 GMT

if two tables do not have fields in common, how do you make a relationship between the two tables or make sure you use both?

( join of table? database logical? )

Re: query sql

Sandra_Rossi — Tue, 10 Dec 2019 10:04:22 GMT

"logical database" is obsolete since XXth century...

Re: query sql

FredericGirod — Tue, 10 Dec 2019 10:09:43 GMT

if you have two tables without relation, you cannot create relation

are they standard tables ?

Re: query sql

Former Member — Tue, 10 Dec 2019 10:43:07 GMT

yes, the tables are standard

Re: query sql

sdsunny372 — Tue, 10 Dec 2019 10:49:01 GMT

Hi Nick Reyan,

In this kind of scenario,we need to use mediator table for joining.

For brief understanding have a look on below example.

Example:-

In our past requirement ,we were trying to find join between EBAN & AFIH. Astehre is no direct link between these 2 tables,so we had used mediator table EBKN.

So joinings flow is EBAN -> EBKN ->AFIH

1)Between EBAN-EBKN tables

EBAN.BANFN = EBKN.BANFN & EBAN.BNFPO = EBKN.BNFPO

2)Between EBKN-AFIH tables

EBKN.AUFNR = AFIH.AUFNR

Best Regards,

Sagarkumar Darji

Re: query sql

ThangaPrakash — Tue, 10 Dec 2019 15:58:48 GMT

what are the 2 tables which you are referring to? Once you provide we will try to check how both can be linked