I have two tables named articles and writers.
articles table looks like this :
writers table looks like this:
A few of the articles could be translated but mostly self written articles. The writer_id and translator_id are from writers table. A writer could write an article as well as translate an article. How could I query for all articles that has writers name and translators name if that article has a translator too.
1,1,2,"How to do it";
2,1,0,"my job is this";
pls help me with the problem.