I have a number of tables that I'm trying to access in CodeIgniter, and one of them is basically a collection of foreign keys from the other tables, most of which are only two fields: a unique id and a name. The "campaigns" table, let's call it, pulls data from other tables in the form of those tables' ids (because the names may not be unique).
Now what I want to do is display the "campaigns" data in human-readable form, meaning, showing the foreign names, not the ids. I think this is called a 'join,' but I'm not 100% certain on that. I checked MySql's page and they say that that isn't actually what foreign keys are for, but I thought that you needed foreign keys for a join, so I'm really just more confused now.
Do I really use joins and foreign keys for this? Thanks in advance.