# Select All Series Tags

If rows for the retrieved series contain different tags, the tags.* expression is expanded to all unique tag names.

If series does not contain the given series tag, the tag value is set to null in the corresponding column.

# Data

series d:2016-06-19T11:00:00.000Z e:e-sql-1 m:m-metric1=1 t:tag1=val1
series d:2016-06-19T11:00:00.000Z e:e-sql-2 m:m-metric1=2 t:tag1=val2 t:tag2=val2
series d:2016-06-19T11:00:00.000Z e:e-sql-3 m:m-metric1=3 t:tag2=val3
series d:2016-06-19T11:00:00.000Z e:e-sql-4 m:m-metric1=4 t:tag4=val4

# Query

SELECT entity, datetime, value, tags.*
  FROM "m-metric1"
WHERE datetime >= '2016-06-19T11:00:00.000Z' AND datetime < '2016-06-19T12:00:00.000Z'

# Results

| entity  | datetime                 | value | tags.tag1 | tags.tag2 | tags.tag4 |
|---------|--------------------------|-------|-----------|-----------|-----------|
| e-sql-1 | 2016-06-19T11:00:00.000Z | 1.0   | val1      | null      | null      |
| e-sql-2 | 2016-06-19T11:00:00.000Z | 2.0   | val2      | val2      | null      |
| e-sql-3 | 2016-06-19T11:00:00.000Z | 3.0   | null      | val3      | null      |
| e-sql-4 | 2016-06-19T11:00:00.000Z | 4.0   | null      | null      | val4      |