SitePoint Sponsor |
|
User Tag List
Results 1 to 5 of 5
Thread: How to LEFT JOIN a SubQuery?
Threaded View
-
Nov 23, 2009, 22:42 #1
- Join Date
- Jul 2009
- Posts
- 221
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
How to LEFT JOIN a SubQuery?
What I'm doing here is to add a column (named outOfStock) to my existing table prod_info.
I used this query to generate my outOfStock table.
PHP Code:SELECT prod_id, XS, S, Splus, M, L, XL FROM prod_info AS outOfStock WHERE
XS IS NULL &&
S IS NULL &&
Splus IS NULL &&
M IS NULL &&
L IS NULL &&
XL IS NULL
PHP Code:SELECT * FROM prod_info LEFT JOIN (
SELECT prod_id, XS, S, Splus, M, L, XL FROM prod_info AS outOfStock WHERE
XS IS NULL &&
S IS NULL &&
Splus IS NULL &&
M IS NULL &&
L IS NULL &&
XL IS NULL
) ON prod_info.prod_id = outOfStock.prod_id
Every derived table must have its own alias.
Oh yes, please recommend some really simple reading on joins and subqueries. Most that I'd seen are quite difficult to understand.
Bookmarks