Any tips on what I'm doing wrong here? Table schema is Requests:
SELECT CategoryDefinition.Categoryname, WorkOrder.Title, WorkOrder.Description, RequestResolution.Resolution FROM WorkOrder JOIN RequestResolution ON WorkOrder.workorderid=RequestResolution.requestid Workorder JOIN WorkOrderStates ON WorkOrder.workorderid=WorkOrderStates.workorderid WorkOrderStates JOIN CategoryDefinition ON WorkOrderStates.categoryid=CategoryDefinition.categoryid
When I run that, I get "java.sql.SQLException: Incorrect syntax near 'Workorder'."