Error 1051: Unknown table

[Exie Smith]

Hello,

I have written a simple query with a series of inner joins in MySQL Workbench. In the query, I have aliased and fully written out one of the tables I am referencing but I keep getting a 1051 Error for Unknown table.

My initial thought was spelling error but after changing several times and receiving the same error each time that leads me to believe there is a bigger issue at hand. Has anyone else seen this type of behavior?

I am on MySQL workbench 5.2.37 and the query I am writing is below with the portion that is giving me issues commented out:

use kayako_fusion;
select t.*
, cfv.*
-- , swcustomfields.*
, cfo.*
, dep.title
, ts.title
from swtickets t
inner join swdepartments dep
on t.departmentid = dep.departmentid
inner join swticketstatus ts
on t.ticketstatusid = ts.ticketstatusid
inner join swcustomfieldvalues cfv
on cfv.customfieldid = swcustomfields.customfieldid
-- inner join swcustomfields cf
-- on cf.customfieldid = cfo.customfieldid
inner join swcustomfieldoptions cfo
on cfo.customfieldid = cfol.customfieldid
inner join swcustomfieldoptionlinks cfol
on cfol.customfieldoptionlinkid = cfl.customfieldoptionlinkid
inner join swcustomfieldlinks cfl
on cfl.customfieldgroupid = customfieldgroups.customfieldgroupid