Closed vakorol closed 10 years ago
in_sel2 = SQLConstructor.new( :dialect => 'mysql', :tidy => true ).select( :"d.guest_id" ).from( :guest_data => :d ).inner_join( :host_data => :h ).on.eq( :"d.guest_nm", :hhost_nm ).group_by( :"h.venue_nm" ).where.eq( :"COUNT(*)", 1 )
then p( in_sel2 ) prints "(COUNT(*) = 1)"
+
in_sel2 = SQLConstructor.new( :dialect => 'mysql', :tidy => true ).select( :"d.guest_id" ).from( :guest_data => :d ).inner_join( :host_data => :h ).on.eq( :"d.guest_nm", :hhost_nm ).group_by( :"h.venue_nm" ).where.eq( :"COUNT(*)", 1 )
then p( in_sel2 ) prints "(COUNT(*) = 1)"