INNER JOIN

Syntax:

SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2
ON table_name1.column_name=table_name2.column_name;


Example:

select *
from CST_KFH_USER cu
inner join CST_USER_GROUP cst
on cu.GROUP_ID=cst.GROUP_ID where  cu.u_deleted=0 order by cu.user_alias desc;