Hello SQL Team, this is my first time here. My apologies if I am breaking any rule with this post. I have a SQL code that I am trying to run, but received syntax error (missing operator in query expression on the following. Can anyone assist?
'JOB.JOB_ID = ACTIVITY.JOB_ID
INNER JOIN BUILD.WIRE_CENTER WIRECENTER ON JOB.WC_ID = WIRECENTER.WC_ID
INNER JOIN BUILD.TASK TASK ON ACTIVITY.TASK_ID = TASK.TASK_ID
INNER JOIN BUILD.ACT_MATERIAL ACTMATERIAL ON ACTIVITY.ACTIVITY_ID = ACTMATERIAL_ID'
Welcome!
All looks good except we are not seeing the top select section
Thank you. Below is the select statement:
SELECT
DISTINCT WIRECENTER.STATE AS "STATE",
WIRECENTER.NAME AS "WC NAME",
WIRECENTER.WC AS "WC NUM",
JOB.JOB_NUMBER AS "JOB NUMBER",
ACTIVITY.ACT_LOC AS "LOCATION",
VWJOBACTIVITYMAT.MAT_CATEGORY AS "MAT CATEGORY",
JOBDATES.JOB_DATE AS "JOB DATE",
JOB.STATUS_CODE AS "JOB STATUS",
ACTMATERIAL.ACT_MAT_ORDER_QTY AS "ACT MAT ORDER QTY",
ACTMATERIAL.ACT_MAT_DISB_QTY AS "ACT MAT DISB QTY",
ACTMATERIAL.ACT_MAT_SIZE AS "ACT MAT SIZE",
ACTMATERIAL.ACT_MAT_CPR_QTY AS "ACT MAT CPR QTY",
ACTIVITY.STATUS_CODE AS "ACTVIITY STATUS",
ACTIVITY.FRC_ACCT_CODE AS "FRC ACCT CODE",
MATCATALOG.DESCRIPTION AS "MAT DESCRIPTION"
FROM
BUILD.JOB JOB
INNER JOIN BUILD.ACTIVITY ACTIVITY ON JOB.JOB_ID = ACTIVITY.JOB_ID
INNER JOIN BUILD.WIRE_CENTER WIRECENTER ON JOB.WC_ID = WIRECENTER.WC_ID
INNER JOIN BUILD.TASK TASK ON ACTIVITY.TASK_ID = TASK.TASK_ID
INNER JOIN BUILD.ACT_MATERIAL ACTMATERIAL ON ACTIVITY.ACTIVITY_ID = ACTMATERIAL.ACTIVITY_ID