Hi,

I have a table workorder and a table category.

workorder.category (String) which holds the name of the category.
category.department (String) the department the category belongs to.

If given a department name, is there an easy way to filter all the workorder that has that department?
workorder holds the category name, and category holds the department name. I am not sure how to link these two tables together to do this search.

You don't know how to write a JOIN? Can't you just join the Category columns of both tables?

At first I though a join wasn't what I was looking for, but figured it out. Was quite easy