Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

And, as I mentioned in another tip, if you want to mix some update commands in with your Select statements, you can do that, too -- saving you even more trips. I wouldn't suggest that combining these ...

create of replace view stuff select id, value1, value2, 1 as type from tab2 union all select id, value1, value2, 2 as type from tab1 where tab1_value1 = "B" and tab1_value2 <> "C" union all ...