I have two tables, attendance_21BE and logon_times_21BECW. They both have a column studentnr and columns for Week1 to Week19.
This query gets the data for a particular student. Is there some way to make it display in two lines, attendance on top and logon time underneath?
SELECT * FROM attendance_21BE JOIN logon_times_21BECW WHERE attendance_21BE.studentnr = 1234567890 AND logon_times_21BECW.studentnr = 1234567890