Looking up data in a database
You already know how to create, update, and delete data from a database. It's now time to learn to look up data. Lookup is the act of searching for information in a database. You can look up a column of a single table or you can do more complex lookups. Let's begin with the simplest way of looking up.
Doing simple lookups
Sometimes you need to get information from a database table based on the data you have in your main stream. Let's see how you can do it.