I have two tables where the first one relates to the second one from two fields, and I'm not sure how to set up a query properly. Tables look like:
I want to select the code and name for both the main and related code, so the output would have columns like this:
main.code | main.name | related.code | related.name
Could someone point me in the right direction?