Upgrade StorageGet Notes
I am trying to extract the notes for a specific collection, but this does not seem to work. The solution name is call "VIP". Can anyone help me with the Schema links?
Thank you.
// get all the notes from a specific collection
SELECT note, collections.collectionName from itemNotes, collections, collectionItems, items
WHERE collections.collectionName = "VIP"
AND collections.collectionID = collectionItems.collectionID
AND collectionItems.itemID = Items.itemID
AND ItemNotes.itemID = Items.itemID
Thank you.
// get all the notes from a specific collection
SELECT note, collections.collectionName from itemNotes, collections, collectionItems, items
WHERE collections.collectionName = "VIP"
AND collections.collectionID = collectionItems.collectionID
AND collectionItems.itemID = Items.itemID
AND ItemNotes.itemID = Items.itemID