Writing an SQL SELECT statement

Question

I'd like to Select columns from Table 1 with a Row Filter, Select columns from Table 2 and join.

This works but it's a bit verbose. I was wondering if there is a cleaner way to write this.

SELECT * FROM 
  ((SELECT JOB_NUM, ITEM_NUMBER, DATE_COMPLETED, QTY_COMPLETED, STD_USAGE, ACTUAL_USAGE FROM JOB_ROUTERS WHERE RESOURCE_CODE == "TDWELD") AS JOBS
 LEFT JOIN
(SELECT ITEM, DESCRIPTION FROM ITEM_ATTRIBUTE) as item
  ON JOBS.ITEM_NUMBER == ITEM.ITEM)

rolfl · Accepted Answer · 2015-06-13 15:59:15Z

3

There is no need to do the deep abstraction for the Select *. You can simply reference the columns you want and include them in the result...

SELECT JOB_NUM,
       ITEM_NUMBER,
       DATE_COMPLETED,
       QTY_COMPLETED,
       STD_USAGE,
       ACTUAL_USAGE,
       ITEM,
       DESCRIPTION
FROM JOB_ROUTERS
LEFT JOIN ITEM_ATTRIBUTE
       ON JOBS.ITEM_NUMBER == ITEM_ATTRIBUTE.ITEM
WHERE RESOURCE_CODE == "TDWELD"

answered Jun 13, 2015 at 15:59

rolfl

98.1k17 gold badges220 silver badges419 bronze badges

Add a comment |

Stack Exchange Network

Writing an SQL SELECT statement

1 Answer 1

You must log in to answer this question.

Hot Network Questions

Writing an SQL SELECT statement

1 Answer 1

You must log in to answer this question.

Related

Hot Network Questions