Hi Richard, if you have multiple Tables and want to select the "*" from one of them, would you say: SELECT Table.* ?

---

Reply from Alex Hedley:

Indeed, you can choose the Fields by putting their Table name in front.
Often you would alias the Table so
SELECT t.field1 FROM Table t
Instead of
SELECT Table.field1 FROM Table
Makes it easier and less typing, we are lazy programmers and anything to make life quicker and easier :p