Liveware Publishing Support Forum

In R&R SQL v9 is it possible to join table on a calculated field containing a SQLEXP() function and a field?____Is this a limitation of R&R?____Thanks Kathleen,____Morna

Unfortunately not.__There is a bug that prevents you from using SQLEXP() fields in a join. It will appear in the available join field list but then you will not be able to ok the join.____The workaround would be to create a User SQL report where you would manually input your SELECT statement.____Kathleen__R&R Support