Query RelType

SELECT [RelType].[Label], [RelType].[Type], [InvRelType].[Label] as [InvLabel], [InvRelType].[Type] From ([RelType] left Join [RelType] as InvRelType on ([RelType].[Id] = [InvRelType].[InvRelTypeId] and [InvRelType].[DBId] = @DBIdInvRelType@)) where...

Query: Select Companies having double VAT Numbers

Select Replace([IBLCNum],’ ‘, ”), [Name] from [Company] where [DBId] = 3 and Replace([IBLCNum],’ ‘, ”) in (Select Replace([IBLCNum],’ ‘, ”) from [Company] where not [IBLCNum] = ” and [DBId] = 3Group by...

Query: Select Countries and Translations

SELECT [Country].[Name], [Language].[Name], CountryName.Name, CountryName.Nationality from (([Country] Left Join [CountryName] ON ([Country].[Id] = [CountryName].[CountryId] and [CountryName].[DBId] = 0)) LEFT JOIN [Language] ON ([CountryName].[LanguageId] =...