mrc_titles is a temp table?
On Wed, Oct 15, 2008 at 11:59 PM, Jerry Schwartz <[EMAIL PROTECTED]
> wrote:
> I tried to make a query that joins to subqueries:
>
>
>
> SELECT discontinued.b
>
> FROM
>
> (SELECT mrc_titles.title AS a
>
> FROM mrc_titles JOIN prod ON mrc_titles.tit
I tried to make a query that joins to subqueries:
SELECT discontinued.b
FROM
(SELECT mrc_titles.title AS a
FROM mrc_titles JOIN prod ON mrc_titles.title = prod.prod_title
JOIN pub ON prod.pub_id = pub.pub_id
WHERE pub.pub_code = "MRC"
