Re: Getting most records possibly from an Inner/Left Join

2023-11-19 Thread Achilleas Mantzios
Στις 19/11/23 13:42, ο/η Anthony Apollis έγραψε: For sample data in Excel see https://drive.google.com/file/d/17aOmG-Ynx-6U05wNNrHXJG7iywgCMiuy/view?usp=sharing Please note that you can increase the chances of having your thoughts be read if you describe your problem using SQL or something t

Getting most records possibly from an Inner/Left Join

2023-11-19 Thread Anthony Apollis
For sample data in Excel see https://drive.google.com/file/d/17aOmG-Ynx-6U05wNNrHXJG7iywgCMiuy/view?usp=sharing (1) The fact table is from SAP. (2) Dimension Tables are named "B Masked". Please note that none of the tables had primary keys, I had to bring them in myself. In the Bracs Mapping tab