If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Join 2 tables
Hello,
I am a very basic user of MS Access. I love the functionality of it and would love to learn more. Here is my situation. I have started up a query that includes 3 tables. One main database(Table A) and the other two are conversion tables(Tables B & C). The query works with no issues. Now, I would like to add another major database(Table D). I believe that I have linked up the joins correctly. However, I noticed that it is only doing a match between Table A and Table D. I would like to include ALL records from both Tables A and D. How do I do that? I appreciate any feedback. Have a nice day! |
#2
|
|||
|
|||
Join 2 tables
SELECT [DC Conversion].DC, [2010 AOPII with Benefits].DC, [2010 AOPII with
Benefits].[SAP GL], [Category conversion].Category, [SAP P4 GL].[COST ELEMENT], [Category conversion].[Cost Element Name], Sum([SAP P4 GL].P4) AS SumOfP4, [2010 AOPII with Benefits].P4 FROM [2010 AOPII with Benefits] INNER JOIN (([SAP P4 GL] INNER JOIN [DC Conversion] ON [SAP P4 GL].[COST CENTER] = [DC Conversion].[SAP Cost Center]) INNER JOIN [Category conversion] ON [SAP P4 GL].[COST ELEMENT] = [Category conversion].[SAP GL]) ON ([2010 AOPII with Benefits].[SAP GL] = [Category conversion].[SAP GL]) AND ([2010 AOPII with Benefits].Category = [Category conversion].Category) AND ([2010 AOPII with Benefits].DC = [DC Conversion].DC) GROUP BY [DC Conversion].DC, [2010 AOPII with Benefits].DC, [2010 AOPII with Benefits].[SAP GL], [Category conversion].Category, [SAP P4 GL].[COST ELEMENT], [Category conversion].[Cost Element Name], [2010 AOPII with Benefits].P4; Here is the SQL version...does this help? "MrRJ" wrote: Hello, I am a very basic user of MS Access. I love the functionality of it and would love to learn more. Here is my situation. I have started up a query that includes 3 tables. One main database(Table A) and the other two are conversion tables(Tables B & C). The query works with no issues. Now, I would like to add another major database(Table D). I believe that I have linked up the joins correctly. However, I noticed that it is only doing a match between Table A and Table D. I would like to include ALL records from both Tables A and D. How do I do that? I appreciate any feedback. Have a nice day! |
Thread Tools | |
Display Modes | |
|
|