Under the Table
- 2 ounces Licor 43
- 3 ounces tequila
- 1 tablespoon fresh lemon juice
- 3 tablespoons fresh orange juice
- Dash bitters
Just a straight forward create table template.
Update from one table to another
Delete using a join.
Copy from a table in one database to a new table.
Lets say you want to replace "bob" with "Bob", you would do this.
"bob" would be what you want to search for and replace 'a'
and "Bob" is want you want to put in. 'b'
Here is how you would do it.
Delete duplicate records.
Or maybe you just want to find where there are duplicates, or filter out the unique records.