I have two tables
Table one includes a column that lists the statistical categories for an application. Basically a lookup up table.
Table two is a table that includes the value of the column in table one plus a column for the user i.d. Basically a table that store the defaults for ALL users.
How can I write a query that will display ALL the records in table one with a column that displays whether a selected user has subscribed to those values.
I can not seem to find a join that works as I need to add a where clause to the second table to filter the user.