samedi 30 janvier 2016

IS there a way TO transform the following SQLite query USING ActiveAndroid query?

This is my code:

SELECT USER.userName, COUNT(reservation.userID), SUM(price) PricePerUser FROM USER 
      JOIN reservation ON reservation.userID = USER.userID 
      JOIN venue ON venue.venueID = reservation.venueID 
      JOIN TIME ON reservation.timeID = TIME.timeID GROUP BY USER.[userName]

Aucun commentaire:

Enregistrer un commentaire