query sql

[Former Member]

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? )

[Sandra_Rossi]

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

[FredericGirod]

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

are they standard tables ?

[Former Member]

yes, the tables are standard

[sdsunny372]

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

[ThangaPrakash]

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