Extract data from not connected tables??
I have to extract data from fields PERNR, WORKDATE, CATSHOURS, RAUFNR and AWART, from table CATSDB.
And from fields BTRTL and ENAME, from table PA0001.
And from fields LGART, BETRG and ANZHL, from table PPOIX.
Table PA0001 and PPOIX both has PERNR as primary key So, no problem to join them.
But table CATSDB does not have any primary key common to both PPOIX or PA0001 tables.
Can anyone please help me to how to extract data from those, not connected tables.
Please help me for this problem.
Thanks in advance.