I've bought your whole package and I like it very much. However: I read your short instruction about merging different tables in a new table/view. I always get syntax errors. The solution to my problem is probably quite simple, but I just can't do it. Please help.
I want to generate a new table/view for articles (jos_content).
Jos_content contains the columns id / introtext / catid / created by
I want to replace the column "catid" with the title of the category (jos_categories,column "title").
I want to replace the column created_by" with the name of the user (jos_users, column "name".)
It is that simple! But I don't manage it.
The final table should look like
article name / category name / name of the author
Thank you for your help!
Ari
