SHARE
TWEET

Untitled

a guest Jun 15th, 2019 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Id         | Zip_Code    | Address
  2. 0123       | 90210       | 1 Acacia Avenue
  3.      
  4. Premise_ID | Name        | Value
  5. 0123       | DoorColor   | Green
  6. 0123       | WindowCount | 4
  7.      
  8. Select * from Premises
  9. Left join
  10. (select * from Premise_Param
  11. where Name = "DoorColor") doorColor on doorColor.Premise_ID = Premise.ID
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top