For school I have to do this:
Query what salary scale an employee belongs to displaying these columns:
s_schaal.schaal, werknemer.name, werknemer.salaris
But there are no identifiers between the tables. All I have is a bottom line and upper line column (s_schaal.ondergens & s_schaal.bovengrens).
What MySQL query can I use to compare and join this data?