KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Is is possible to store a mysql subquery somehow, if it will be used again as a subquery? Presumably this would produce cleaner code as well as save parsing overheads. For example in the following outer join SELECT * FROM t1 LEFT JOIN (SELECT * FROM t2 WHERE t2.foo=='bar') ON t1.id = t2.id UNION SELECT * FROM t1 RIGHT JOIN (SELECT * FROM t2 WHERE t2.foo=='bar') ON t1.id = t2.id It would be nice not to repeat (SELECT * FROM t2 WHERE t2.foo=='bar') .
Tags (comma-separated)
Save Edits
Cancel