How should I select columns from multiple tables where table are not related

Aug 25, 2016 at 7:24 AM
Edited Aug 25, 2016 at 8:09 AM
How should I select columns from multiple tables where table are not related ?
Something like this:-
SELECT
dbo.tb_admin_groups.GroupId,
dbo.tb_admin_groups.GroupName,
dbo.tb_cms_languages.LanguageName
FROM
 dbo.tb_admin_groups, dbo.tb_cms_languages;

tables .tb_admin_groups and tb_cms_languages are not related as in they don't have a foreign key relationship.