SushmaBaliza

dataBinding
{
   enabled = true
}

SushmaBaliza

<?xml version="1.0" encoding="utf-8"?>
<layout
    xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools">

    <android.support.constraint.ConstraintLayout
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        tools:context="com.processmap.databindingexample.MainActivity">

SushmaBaliza

import android.databinding.DataBindingUtil
import android.support.v7.app.AppCompatActivity
import android.os.Bundle
import com.processmap.databindingexample.databinding.ActivityMainBinding
class MainActivity : AppCompatActivity() {

    private var mBinding: ActivityMainBinding? = null   //This ActivityMainBinding class is auto generated by data binding library for us


    override fun onCreate(savedInstanceState: Bundle?) {

SushmaBaliza

SELECT a.Emp_id, a.Emp_name,a.Emp_Hire_date,b.Dept_name
FROM employees a
LEFT JOIN departments b
ON a.Dept_id=b.Dept_id
ORDER BY  a.Emp_id;

SushmaBaliza

SELECT a.Emp_id, a.Emp_name,a.Emp_Hire_date,b.Dept_name
FROM Employees a
LEFT OUTER JOIN Departments b
ON a.Dept_id = b.Dept_id;

SushmaBaliza

SELECT a.Emp_id, a.emp_name,b.Dept_name
FROM employees a
CROSS JOIN departments b;

SushmaBaliza

SELECT a.Emp_id, a.Emp_name, b.Department_name
FROM Employees a
CROSS JOIN Departments b;

SushmaBaliza

SELECT a.Emp_id, a.Emp_name,b.Dept_name
FROM employees a
INNER JOIN departments b
ON a.Dept_id=b.Dept_id;

SushmaBaliza

SELECT a.emp_id, a.emp_name, b.Department_name
FROM employees a
INNER JOIN Departments b
ON a.Dept_id = b.Dept_id;

SushmaBaliza

SELECT a.Emp_id, a.Emp_name,a.Emp_Role,b.Dept_id,b.Dept_name,b.Location
FROM employees a
RIGHT JOIN  departments b
on a.Dept_id = b.Dept_id
ORDER BY a.Emp_id;