SELECT  pt.KeyCOlumn,
        pt.SomeColumn,
        ct.OtherColumn
FROM    ParentTable pt
        JOIN ChildTable ct ON pt.KeyColumn = ct.KeyColumn;

CREATE TABLE dbo.TicketPriority (
 TicketPriorityID TINYINT NOT NULL
                          CONSTRAINT [PK_dbo.TicketPriority] PRIMARY KEY CLUSTERED,
 -- renamed TicketPriority because Priority is a keyword
 Name VARCHAR(100) NOT NULL);
GO

CREATE UNIQUE INDEX [IX_dbo.TicketPriority.Name] ON dbo.TicketPriority (Name); -- alternate key
GO

CREATE TABLE dbo.Ticket
(
 TicketNumber INT NOT NULL CONSTRAINT [PK_dbo.Ticket] PRIMARY KEY CLUSTERED,
 TicketPriorityID TINYINT NOT NULL,  -- refactored into lookup table
 Assignee VARCHAR(25) NULL,
 Category VARCHAR(25) NULL,
 VendorTicket VARCHAR(60) NULL,
 OpenDate DATE NULL,
 Opener VARCHAR(30) NULL,
 Closer VARCHAR(30) NULL,
 CONSTRAINT [FK_dbo.Ticket_dbo.TicketPriority.TicketPriorityID] 
     FOREIGN KEY (TicketPriorityID) 
     REFERENCES dbo.TicketPriority (TicketPriorityID));