Adding Read-Only Fields from Other Tables

Hi,
you can join tables on theEdit SQL querytab, then add joined fields on the Choose field tab and set up these fields as readonly on the "Edit as" settings dialog on the Visual Editor tab.

Hello,
Is there a simpler way? I hate to do a query joining the records and needing to worry about the assignment of primary keys, etc. I understand database theory well enough to know that it can be done and that it is best to do it the "proper" way.
I am looking for quick shortcuts though. Is there any way to simply have a field that references another table without worrying about the SQL joins? I briefly played with the SQL join and sent my computer into an infinite loop. It isn't as if my aversion is completely for naught.
Thank you,

Joseph Irvine

You can also use "Insert PHP code snippet" function in Visual Editor where you can run SQL query and display results on the page.