First_name is Joe
Last_Name is Smith
Zipcode is 12345
Join_date is 05012011
xmldata is
Expand|Select|Wrap|Line Numbers
- <data>Network Admin</data>
- <definition_field_id>beaa46b0-d1bb-408a-a5cc-56764f8562b6</definition_field_id>
- <validation_status>Valid</validation_status>
- <field>
- <data>Idontknow_noidea@noemail.net</data>
- <definition_field_id>a1cf1da8-7924-428b-b6b2-4315402738d9</definition_field_id>
- <validation_status>Valid</validation_status>
How do I write a select query in SQL that will extract the email in a SQL query so my results can look like:
Joe, Smith, 12345, 05012011, Idontknow_noidea@noemail.net for the First_name, Last_Name, Zipcode, Join_date and email headers respectively?
Thanks