Looking up data in a database
You already know how to create, update, and delete data from a database. It's time to learn how to look up data. Let's call lookup as the act of searching information in a database. You can lookup 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 data you have in your main stream. Let's see how you do it.