Drop Shadow

Multiple Tables

There are a few ways to work with multiple tables in the Easy SQL plug-in, depending on what you want to do with the tables.

Joining multiple tablesThe most common means of using secondary tables is to join them to your main table.
Lookup restrictionsOften, you’ll have a lookup table and you need to get only the records that match some field in that lookup table.
Match lookupSometimes you’ll need to look up some info in another table based on a value that you have.
Multiple ChoiceIf a column in your table must contain a value from another table, that’s a foreign key. If you tell the plug-in about that foreign key, it will automatically display a checkbox, radio button, or pull-down menu in forms as appropriate.
Switching tablesIf you need to display completely unrelated data on the same page, you can switch tables.