CodingForums.com - View Single Post

Dormilich · 12-11-2012, 11:02 AM

that can be done by a simple join.

Code:

SELECT
    -- fields here
FROM
    table_a
JOIN
    table_b USING (id)
WHERE
    table_a.is_set = 1;

12-11-2012, 11:02 AM	PM User \| #4
Dormilich Senior Coder Join Date: Jan 2010 Location: Behind the Wall Posts: 2,907 Thanks: 10 Thanked 293 Times in 289 Posts	that can be done by a simple join. Code: SELECT -- fields here FROM table_a JOIN table_b USING (id) WHERE table_a.is_set = 1; __________________ please post your code wrapped in [CODE] [/CODE] tags