pcsoft.us.windevCopyright 2026, PC SOFT3 Apr 2016 08:38:00 Z30 Mar 2016 17:50:00 ZHi everyone - I need to create a query, but not sure how to do it - I figure I nee several queries and them UNION them together. First I need a select all records in the database that have enrollments - that's easy. The next step is to look at the Attendance database and only keep the records from the first query that have some records in the attendance database. This way if there's no attendance records yet, I don't need to worry about absentees. Finally, out of the records that are left, I need to figure out who hasn't had an attendance record in the last "X" days. So someone that hasn't checked in in the last 10 days or so would be left in the list. I probably can figure most of this out, but I really have no idea how to exclude records that have no attendance records at all. Appreciate any help!30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57116-wb19-need-help-with-sql-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57116-wb19-need-help-with-sql-query-57166/read.awp3 Apr 2016 08:38:00 ZThanks everyone! Appreciate the input!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57116-wb19-need-help-with-sql-query-57166/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57116-wb19-need-help-with-sql-query-57166/read.awp[WB19] need help with SQL queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57116-wb19-need-help-with-sql-query-57118/read.awp30 Mar 2016 18:31:00 Zwhitout knowing your db tables structure and database type (HF/CS, MYSQL,...) is dificult but you don't need several queries for…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57116-wb19-need-help-with-sql-query-57118/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57116-wb19-need-help-with-sql-query-57118/read.awp[WB19] need help with SQL queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57116-wb19-need-help-with-sql-query-57117/read.awp30 Mar 2016 18:16:00 ZJoel, I assume you are using Mysql. If so, make an sql query - xdate is user defined - your X days select * from enro…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57116-wb19-need-help-with-sql-query-57117/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57116-wb19-need-help-with-sql-query-57117/read.awp[WB19] need help with SQL query