How can i merge 4 query in grafana 7

i have four datasource:
1.hostname have a table hostname which have two columns: hostname and sn
2.idc have a table idc which have two columns: idc and sn
3.ipmi have a table ipmi which have two columns: ipmi and sn
4.user have a table user which have two columns: user and sn
i can merge these four query into one table in grafana 6:


but i can’t merge them in grafana 7 in the same way:

grafana 6 and grafana 7 both read from the same dabasources.

i have the same problem, could anyone help on this?