Search results

Eliminating the extra "On" does the trick. Now I have the results I want with: SELECT RETURNS.Coding, RETURNS.MM_DD_YYYY, RETURNS.Performance, ASSETS.Assets_Managed FROM RETURNS LEFT JOIN ASSETS ON RETURNS.Coding = ASSETS.Coding And RETURNS.MM_DD_YYYY = ASSETS.MM_DD_YYYY;

If I integrate the junction table the query should look like this: SELECT ADMINISTRATIVE.Coding, ADMINISTRATIVE.Name, RETURNS.Coding, RETURNS.MM_DD_YYYY, RETURNS.Performance, ASSETS.Assets_Managed FROM ADMINISTRATIVE INNER JOIN(RETURNS LEFT JOIN ASSETS ON RETURNS.Coding = ASSETS.Coding AND ON...

I agree! This is what I wrote as a query (as I expect the default query would be an inner join): SELECT RETURNS.Coding, RETURNS.MM_DD_YYYY, RETURNS.Performance, ASSETS.Assets_Managed FROM RETURNS LEFT JOIN ASSETS ON RETURNS.Coding = ASSETS.Coding AND ON RETURNS.MM_DD_YYYY = ASSETS.MM_DD_YYYY...

I'm afraid I'm going around in circles. A select query is what I started out with. I had RETURN and ASSETS table joinded by a junction table (the relation is one-to-one). I assigned identical composite primary keys to RETURN and ASSETS in order to merge the information contained in both tables...

Coding MM_DD_YYYY AnyName 9 31/1/1994 -2.56% --> Performance 9 31/1/1994 9.653 --> Assets under Management 9 28/2/1994 1.23% 9 28/2/1994...

Okay, the union query works, but not as intended. What I would like to have is a query with four columns where Performance and Assets are adjacent. The fields Coding and MM_DD_YYYY are identical for Performance and Assets. The union query now looks as follows (example): Coding

Used the Union query with the following sql-thread: Select [Coding,[MM_DD_YYYY],[Performance] From RETURNS UNION Select [Coding],[MM_DD_YYYY],[Assets] From ASSETS; Result as follows [Coding],[MM_DD_YYYY],[Performance] Coding1, MM_DD_YYYY1, Performance1 Coding1, MM_DD_YYYY1, Assets1...

okay, the table fields look like this now: ADMIN.[Coding],[Fund],[Country] PERFORMANCE.[Coding],[Fund],[MM_DD_YYYY],[Return] ASSETS.[Coding],[Fund],[MM_DD_YYYY],[Assets] the query: [Coding],[Fund],[Country],[MM_DD_YYYY],[Return],[Assets] still no change, any further suggestions?

Thanks for the quick reply, the field names are sponsored by the database provider but I will alter them manually and see what the results are.

Hi everyone, I have the following three tables in my database: ADMIN.[Code],[Name],[Country] PERFORMANCE.[Code],[Name],[Date],[Return] ASSETS.[Code],[Name],[Date],[Assets] The first table contains general information about an investment fund, the primary key is Code (unique). The other two...