Hi All,
I am trying to create a bit of SQL that will give me an output showing which productions have a production description TKW attached but I can't work out which table would give me that detail.
Any help greatfully received
Ean
I'm not sure I explained the above very well so I'll try and expand.
We have created a TKW Category called performance description and then within that category a number of TKW entries that define a production interest base (e.g comedy, children etc)
These interests are then attached to productions under keywords. We now want to be able to produce a list of which productions have which keywords but I can't work out which table stores that info.
Hope that makes a bit more sense LOL