Use the
button at the bottom of this window!
Examples in the
relate to the current TAP service.
[WITH <name> AS (SELECT ...), ...] SELECT [TOP n] <select-list> FROM <table-and-join-expression> [WHERE <conditions>] [GROUP BY <column-list>] [HAVING <conditions>] [ORDER BY <column-list>]
SELECT t.<col1> AS a, t.<col2> AS b FROM <table> AS t
SELECT * FROM <table1> JOIN <table2> ON <expression>
<column> LIKE '%star%'
('%
' matches string, '_
' matches single character)
<column> = 0
<column> IS NOT NULL
<column> BETWEEN 0 AND 100
SELECT ... FROM <table1> JOIN <table2> ON <expression>
SELECT ... FROM <table1> JOIN <table2> USING (<common-column-list>)
SELECT ... FROM <table1> AS a JOIN <table2> AS b ON DISTANCE(a.ra, a.dec, b.ra, b.dec) <= <radius-in-degrees>
Reference TOPCAT tables as TAP_UPLOAD.t<n>
;
table 3 in Control Window list is TAP_UPLOAD.t3
.
Not all services support upload joins.
GAVO ADQL Cheat Sheet (PDF, ADQL 2.0) (http://docs.g-vo.org/adqlref/)
GAVO ADQL Introduction (http://docs.g-vo.org/adql/)
ADQL 2.1 Draft Standard (https://www.ivoa.net/documents/ADQL/20230418/)