Building a Cross Join

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
RRExplorer
Posts: 9
Joined: Tue Oct 10, 2017 12:44 pm

Building a Cross Join

Post by RRExplorer » Fri Oct 08, 2010 11:54 am

Is there a way to build a Cross Join report in RR SQL, a report with all of the records from two tables, regardless of a matching key?____It can be done directly with SQL, easily enough. But the SQL Designer in RR doesn^t seem to allow this.____

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Building a Cross Join

Post by kfleming » Mon Oct 11, 2010 7:48 pm

Have you tried creating a New User SQL report where you write the SELECT statement?____Kathleen__R&R Support

Post Reply