title: SQL Appending Missing Data
body: <p>I'm trying to append placeholder devices in a table where if the device doesn't exist, add it in with dummy data.</p>
  <p>For example:</p>
  <p><a href="https://i.stack.imgur.com/QdNUt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QdNUt.png" alt="enter image description here" /></a></p>
  <p>The Original Table is my current outcome and I'm trying to get the append the missing devices from the device list with the corresponding User IDs and a 0 placeholder for the price and units. I've tried cross joining all the users and did a Union All for all users for each device with a 0 placeholder, but it'll inflate my rows too much. I also did a left join where my original table is the cross joined with the devices and is left joined to the original table to pull in the units and prices, but the numbers came back incorrect.</p>