Matthew256 wrote:
> Captain Paralytic wrote:
> > Matthew256 wrote:
> > > OK, another newbie with a dumb question. Why doesn't my query work?
> > >
> > > SELECT pmainT.product + '.75' + woodtype.short AS SKU, psubT.ID + .75
> > > AS id, ROUND(psubT.price * 1.65, 2) AS price,
> > > psubT.pmain_ID + .75 AS Expr1, psubT.woodtype_ID, psubT.weight * .75 AS
> > > weight, psubT.oldweight, psubT.turning
> > > FROM woodtype INNER JOIN
> > > pmainT INNER JOIN
> > > psubT ON pmainT.ID = psubT.pmain_ID ON woodtype.ID = psubT.woodtype_ID
> > > WHERE (pmainT.milling = 1) AND (pmainT.twosquares = 0)
> > >
> > > MySQL said:
> > > #1064 - You have an error in your SQL syntax; check the manual that
> > > corresponds to your MySQL server version for the right syntax to use
> > > near 'ON woodtype . ID = psubT . woodtype_ID WHERE ( pmainT . milling
> > > = 1 ) AND ( pma' at line 1
> > Because you have your JOINs and ONs all mixed up.
> > Try this (tidied up a bit):
> >
> > SELECT
> > pmainT.product + '.75' + woodtype.short AS SKU,
> > psubT.ID + .75 AS id,
> > ROUND(psubT.price * 1.65, 2) AS price,
> > psubT.pmain_ID + .75 AS Expr1,
> > psubT.woodtype_ID,
> > psubT.weight * .75 AS weight,
> > psubT.oldweight,
> > psubT.turning
> > FROM woodtype
> > INNER JOIN psubT ON woodtype.ID = psubT.woodtype_ID
> > INNER JOIN pmainT ON pmainT.ID = psubT.pmain_ID
> > WHERE (pmainT.milling = 1) AND (pmainT.twosquares = 0)
>
> That did it.
> Thanks for your help!
>
> Matthew

Here's another query question.
I know this looks crazy, but it's a simplified version of my query. I
need to do about five UNION ALLs in the subquery.

CREATE VIEW pmain AS
SELECT original,
ID,
type_ID,
dimensions,
leg_name,
product,
leg_description,
milling,
oversize,
trackproduction,
active,
height,
SORT,
customize
FROM
(SELECT 1 AS original,
ID,
type_ID,
dimensions,
leg_name,
product,
leg_description,
milling,
oversize,
trackproduction,
active,
height,
SORT,
customize
FROM pmainT
WHERE (active = 1)
) AS a
WHERE (active = 1)

MySQL said:
#1349 - View's SELECT contains a subquery in the FROM clause