I love using small CTE's to help with the hassle of the alternative - creating temp tables and then cleaning them up. They can be particularly useful for data modification, as you can't ordinarily do a recursive delete or insert all that easily.
PS: I always cringe when I see this sort of syntax though:
"FROM
users,
tasks,
project"
Much clearer using explicit JOINS imo, especially if your goal is readability.
PS: I always cringe when I see this sort of syntax though: "FROM users, tasks, project"
Much clearer using explicit JOINS imo, especially if your goal is readability.