Examples for USET Drawings form

tap_schema example

This example lists all sunspot drawings with associated sunspot group information.

SELECT * FROM uset_sunspot_drawing.epn_links
        JOIN uset_sunspot_drawing.epn_core on uset_sunspot_drawing.epn_core.granule_uid=uset_sunspot_drawing.epn_links.drawing_ref
        JOIN uset_sunspot_group.epn_core on uset_sunspot_drawing.epn_links.group_ref=uset_sunspot_group.epn_core.granule_uid