Pulling Ticket Information into a Script

V5 Question
9

Am trying… LOL
But my attempts are virtually stabs in the dark…

function test()
{
	qry = "SELECT  [TicketId],[TicketNumber],[TicketTags],[TicketStates],[EntityName],[CustomData],e.[AccountId],a.[Name] as [AccountName],[MenuItemName],[PortionName],[Price],[Quantity],[PortionCount],[CalculatePrice],[OrderTags],[OrderStates] FROM [dbo].[Orders] o JOIN [Tickets] t on t.[Id] = o.[TicketId] LEFT JOIN [TicketEntities] te on te.[Ticket_Id] = t.[Id] LEFT JOIN [Entities] e on e.[Id] = te.[EntityId] LEFT JOIN [Accounts] a on a.[Id] = e.[AccountId] WHERE t.[Id] = 1";
	var ticket = sql.Query(qry);
	return ticket;
}