INNER JOIN but display in two rows

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

Sponsor our Newsletter | Privacy Policy | Terms of Service