SELECT DISTINCT buffer.bufferid, network.networkid, buffertype, groupid, buffername
FROM buffer
JOIN network ON buffer.networkid = network.networkid
SELECT DISTINCT buffer.bufferid, network.networkid, buffertype, groupid, buffername
FROM buffer
JOIN network ON buffer.networkid = network.networkid