What's your favourite go-to query from this site? #sql

Quote from Pat Jones on 2021-02-20, 2:05 amWhat's your favourite go-to query from this site?
Some of us are converting queries written for RM7 to RM8 database format but there are so many it's difficult to know which ones to prioritise.
So please, tell us your favourites, those you use frequently and would like converted. And if you have converted or can convert any yourself please send them in for inclusion to help others.
What's your favourite go-to query from this site?
Some of us are converting queries written for RM7 to RM8 database format but there are so many it's difficult to know which ones to prioritise.
So please, tell us your favourites, those you use frequently and would like converted. And if you have converted or can convert any yourself please send them in for inclusion to help others.

Quote from kevync on 2021-02-28, 7:16 pmI do not yet have a favorite -- brand new to RM. I had been a LONG time user of FTM. About 10 days ago I purchased RM7 and also have been previewing RM8. Very pleased with RM. I like the edit screens of how information is entered . It did take me a couple days of using to get comfortable -- FTM does many things similar while some things very different. One of the added bonuses that attracted to me to RM was the ability to use SQL. Currently, I use SQL (mySQL) on my website database. One of the main drawback is the data is not current with RM (or FTM). So I am excited to explore, once I familiarize myself with the table and db structure.
I do not yet have a favorite -- brand new to RM. I had been a LONG time user of FTM. About 10 days ago I purchased RM7 and also have been previewing RM8. Very pleased with RM. I like the edit screens of how information is entered . It did take me a couple days of using to get comfortable -- FTM does many things similar while some things very different. One of the added bonuses that attracted to me to RM was the ability to use SQL. Currently, I use SQL (mySQL) on my website database. One of the main drawback is the data is not current with RM (or FTM). So I am excited to explore, once I familiarize myself with the table and db structure.