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


  • 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


    Nico Cizik
    Digital Metaphors

    Best Regards,

    Nico Cizik
    Digital Metaphors
  • edited January 2011
    Thanks Nico - the 2 separate queries will work.

    Richard Harding

This discussion has been closed.