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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!