Query: Select missing Language records

Preview in new tab(opens in a new tab)

Use this queries to display invalid records (SQL Query):

• Select [Licence].[DeMaSy].[DBList].[DBId], count(*) from [Licence].[DeMaSy].[DBList] left join [DeMaSy].[DeMaSy].[Language] on [Licence].[DeMaSy].[DBList].[DBId] = [DeMaSy].[DeMaSy].[Language].[DBId]
Group by [Licence].[DeMaSy].[DBList].[DBId] having count(*) < 6