FROM
(
    (
        invoice_headers
    INNER JOIN
        invoice_items
    ON
        invoice_headers.invoice_number = invoice_items.invoice_number
    )
    INNER JOIN
        quote_cost_maintenance
    ON
        invoice_items.art_woods_number 
quote_cost_maintenance.product_number
)
RIGHT OUTER JOIN
(
    (
        (
            sopa
        INNER JOIN
            product_index
        ON
            sopa.category = product_index.category_text
        )
    INNER JOIN
        price_list_3
    ON
        (
        sopa.category = price_list_3.category
        )
    INNER JOIN
        product_index_suggested_retail
    ON
        (
            sopa.novexco_category 
product_index_suggested_retail.novexco_category
        AND
            sopa.catalog_page
        BETWEEN
            product_index_suggested_retail.catalog_page_from AND
catalog_page_to
        )
    )
ON
    sopa.art_woods_number = invoice_items.art_woods_number

I assume this is Access - I think you are missing a set of ( ), since there
are two INNER JOINs at the same level of indentation towards the bottom of
your SQL statement (the second one starts with INNER JOIN
product_index_suggested_retail)

If you run this query inside Access (create a new query, and paste your SQL
into it, it should highlight the point at which it is having problems).

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Jude Camville" <jcamville@y...>
Subject: [sql_language] syntax error in FROM clase


: Can anyone spot the error in my FROM clause?
:
: FROM ((invoice_headers INNER JOIN invoice_items ON
: invoice_headers.invoice_number = invoice_items.invoice_number)
: INNER JOIN quote_cost_maintenance ON invoice_items.art_woods_number 
: quote_cost_maintenance.product_number)
: RIGHT OUTER JOIN
: (((sopa INNER JOIN product_index ON sopa.category 
: product_index.category_text)
: INNER JOIN price_list_3 ON (sopa.category = price_list_3.category)
: INNER JOIN product_index_suggested_retail ON (sopa.novexco_category 
: product_index_suggested_retail.novexco_category AND sopa.catalog_page
: BETWEEN product_index_suggested_retail.catalog_page_from AND
: catalog_page_to))
: ON sopa.art_woods_number = invoice_items.art_woods_number