Ful native SQL support using a command line interface, e.g. being able to use the disinct command

Idea created by infobleep on Sep 29, 2011
    New
    Score50
    • infobleep
    • Jordyn
    • kdunlop
    • Pete_db
    • KerpenGISAdmin
    Hi there

    It would be extremly useful if full native SQL support was offered in ArcGIS. Currently it is not possible to do a distinct query across two tables. Not even when doing a maketable query can this be done.

    I would like to do a one to many join but only on first instance of a row of data being found in one database, rather than every row.

    I believe MapInfo offer something like this.