select
    a.Id
    a.CustomerId,
    a.customerdept,
    CONVERT(VARCHAR(20), ce.LoginDate, 100) AS Check in Date,
    a.Email,
    c.FirstName,
    c.LastName,
    a.StatusId,
    a.ProjectId,
    d.branchname,
    d.releasedate,
    d.companyid
from cust_track a
inner join cust_history b on a.Id=b.Id
inner join cust_detail c on a.CustomerID=b.Customerid
inner join cust_prof d on a.Id=c.Id

Union

select
    a.Id
    a.CustomerId,
    a.worktrack as Tracking,
    CONVERT(VARCHAR(20), ce.StartDate, 100) AS Start Date,
    CONVERT(VARCHAR(20), ce.LogDate, 100) AS Logs,
    a.Email,
    c.MessageId,
    c.MessageDetail,
    b.teamname,
    b.employeename,
    b.supervisorname,
    d.companyid,
    d.companyname
from cust_track a
inner join emp_history b on a.Id=b.Id
inner join cust_detail c on a.CustomerID=b.Customerid
inner join cust_prof d on a.Id=c.Id