CODEWITHSUNDEEP
sql
Amirul Fahmi
Amirul Fahmi

Reputation: 299

SQL select in AS in inner join

I have this kind of query, from that i want to select by category such as Region in ('CENTRAL','EASTERN') as A1 and Region in ('NORTHERN','SOUTHERN') as A2

How to add this in my query?

SELECT
  locinvaisle.Region AS Region,
  sum(sales_data.QUANTITY/1000) AS UnitMT
FROM
  sales_data
  INNER JOIN locinvaisle ON locinvaisle.Location = sales_data.LOCATION
WHERE
 sales_data.unit = 'KG'
 and
 sales_data.CUSTOMERACCOUNT not in ('CT1008','CT1009')
 group by locinvaisle.Region

Upvotes: 0

Views: 61

Answers (1)

flyingfox
flyingfox

Reputation: 13506

I think you can use IF or CASE if your database is common database such as mysql,oracle,mssql:

SELECT
  CASE WHEN locinvaisle.Region = 'CENTRAL' OR locinvaisle.Region = 'EASTERN' THEN 'A1'
  CASE WHEN locinvaisle.Region = 'NORTHERN' OR locinvaisle.Region = 'SOUTHERN' THEN 'A2'
  ELSE 'Default'
  END
    AS Region,
  sum(sales_data.QUANTITY/1000) AS UnitMT
FROM
  sales_data
  INNER JOIN locinvaisle ON locinvaisle.Location = sales_data.LOCATION
WHERE
 sales_data.unit = 'KG'
 and
 sales_data.CUSTOMERACCOUNT not in ('CT1008','CT1009')
 group by Region

Upvotes: 1

Related Questions