If multiple tables are being joined and we did not choose a 'Set' based procedure then an initial dialog will display (as follows) advising that multiple source tables have been detected and that QAD Data Warehouse Designer will only generate one cursor (one join) to handle these tables. If multiple cursors or passes of the data are required, as in scenario (2) in the previous section then it is best to proceed with one set of joins and manually do the second set after the generation of the procedure has completed.