OK, I *DID* have a major cut and past mistake. In Part A the terms in
parentheses in the first CREATE...SELECT... statement should either be
erased or delimited as comments (your choice)
[EMAIL PROTECTED] wrote on 08/23/2005 10:49:33 AM:
<big SNIP>
>
> /* part A - collect the 'required' information */
>
> CREATE TEMPORARY TABLE tmpPartsInfo
> SELECT DISTINCT
> pr.sectionid
> , se.heading1 (t1.text)
should have been:
, se.heading1 /* t1.text */
> , se.heading2 (t2.text)
and so on....
, se.heading2 /*t2.text*/
<another big snip>
My apolgies,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
