1
0
-1
with trivialaccess, I used to be able to do queries such as this: SELECT count(o.EXPNUM) from EXPOSURE@DESOPER o JOIN EXPOSURE@DESSCI s on s.expnum=o.expnum WHERE e.field LIKE 'SN-%' This does not work with easyaccess, and I cannot find information on how to do a query that uses tables in different databases. What is the formatting for such a query?
    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Chris your query worked for me (from DESSCI) using a relatively old version of easyaccess (1.0.7).  I then switched to something a little newer (1.2.0) and it also worked.  Then went and built 1.3.1 there I am getting issues with the METADATA tables and the query is slow but does work.

      Note, I did have to remove a typo in the query you posted with the question.  That being "e.field" should be "o.field" and the query needed a closing ";"

        CommentAdd your comment...