New Blog Post: PDF/A and Metadata

Creating CROSS JOIN query using Query Builder

edited January 2011 in End User
How do I create a cross join query on 2 tables using the query builder?

For example, SELECT a, b FROM Table1, Table2


When the second table is added, query builder requests the join criteria
which does not appear to allow for CROSS JOINS.


Thank you

Richard Harding

Comments

  • edited January 2011
    Hi Richard,

    The QueryDesigner does not natively support cross joins however I would be
    interested to know exactly what you are trying to accomplish. It may be
    easier to simply use two separate queries rather than a single joined one.

    If you must use a cross join, you will need to edit the sql manually in
    DADE.

    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited January 2011
    Thanks Nico - the 2 separate queries will work.

    Richard Harding

This discussion has been closed.