Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Creating CROSS JOIN query using Query Builder

rbuserrbuser
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

  • nicociziknicocizik
    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
  • rbuserrbuser
    edited January 2011
    Thanks Nico - the 2 separate queries will work.

    Richard Harding

This discussion has been closed.