You can select the values from both tables at the same time using a simple INNER JOIN:
SELECT a.BugId,
a.Description,
a.Version,
a.BuildNumber,
a.Category,
a.CreatedDate,
a.Severity,
a.Priority,
a.ReleasePhase,
b.AssignedToID,
b.Resolution,
b.ToStatus
FROM Bugs a
INNER JOIN Bughistory b ON a.BugId = b.BugId;
Also alternately, you can use a view to have these permanently:
CREATE VIEW buginfofull AS
SELECT a.BugId,
a.Description,
a.Version,
a.BuildNumber,
a.Category,
a.CreatedDate,
a.Severity,
a.Priority,
a.ReleasePhase,
b.AssignedToID,
b.Resolution,
b.ToStatus
FROM Bugs a
INNER JOIN Bughistory b ON a.BugId = b.BugId;
And then select from it using:
SELECT BugId, Description, Resolution, ToStatus FROM buginfofull
As for the labels (I am assuming you are referring to table columns here), you can do it as such:
SELECT a.BugId as id,
a.Description as desc,
a.Version as version,
a.BuildNumber as buildnumber,
a.Category as category,
a.CreatedDate as createddate,
[...And so on]
And then, in the result set, you'll have the column labels as defined above.