Remember, I have no idea what your application is. Here's how I parsed your SQL:
Code:
SELECT
[Confirmed Apps].[Application Name],
[Confirmed Apps].[Vendor Technical Requirements],
[Mashzone 2].[L-Link 1],
[Licensing Apps].[SCM Quote],
[Mashzone 1].[L-Link 1]
FROM
( ( [Confirmed Apps]
LEFT JOIN
[Mashzone 2]
ON [Confirmed Apps].[Application Name] = [Mashzone 2].Application
)
LEFT JOIN
[Licensing Apps]
ON [Confirmed Apps].[Application Name] = [Licensing Apps].[Application Name & Version]
)
INNER JOIN
[Mashzone 1]
ON [Confirmed Apps].[Application Name] = [Mashzone 1].Application
GROUP BY
[Confirmed Apps].[Application Name],
[Confirmed Apps].[Vendor Technical Requirements],
[Mashzone 2].[L-Link 1],
[Licensing Apps].[SCM Quote],
[Mashzone 1].[L-Link 1];
Given your description of the issue, your problem is very likely to be in how you created the tables you call [MASHZONE 1] and [MASHZONE 2], but I don't even have a description of those tables.
I do note that you're using GROUP BY in a way that is likely to be unnecessary. Use the "FIRST" keyword if it is possible to get more than one record on a join and they will all have the same value. Also, if you are using a LEFT JOIN, be sure to account for records that have no associated record in the right table - usually the NZ function is useful here.
I'd have to know the relationship between the MASHZONE tables, the [Confirmed Apps] table and the [Licensing Apps] table to code this right, but here's a quick-and-bad SQL query assuming that there is only one [Vendor Technical Requirements] per [Application Name] in the [Confirmed Apps] table, and that there may be multiple MASHZONE records of each type for one App.
By the way, most of us have found that it simplifies our lives immensely, and makes our code easier to read, when we use naming conventions that avoid spaces in the middle of table and variable names. In the next sample, I've aliased the tables to avoid typing all those unnecessary square braces.
Code:
SELECT
tCA.[Application Name] AS AppName,
FIRST(tCA.[Vendor Technical Requirements]) AS AppReqmts,
NZ(FIRST(tLA.[SCM Quote])) AS SCMQuote,
NZ(tM2.[L-Link 1]),"") AS TM2Link,
NZ(tM1.[L-Link 1],"") AS TM1Link
FROM
( ( [Confirmed Apps] AS tCA
LEFT JOIN
[Mashzone 2] AS tM2
ON tCA.[Application Name] = tM2.Application
)
LEFT JOIN
[Licensing Apps] AS tLA
ON tCA.[Application Name] = tLA.[Application Name & Version]
)
INNER JOIN
[Mashzone 1] AS tM1
ON tCA.[Application Name] = tM1.Application
GROUP BY
tCA.[Application Name],
NZ(tM2.[L-Link 1]),""),
NZ(tM1.[L-Link 1]),"")