daily pastebin goal


a guest Dec 16th, 2018 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE VIEW CourierData AS
  2. SELECT Package.ID_courier, Package.ID, Package.ID_client, Package.TelephoneNumber,
  3. r.FirstName AS 'ReceiverFirstName',
  4. r.LastName AS 'ReceiverLastName',
  5. ra.City AS 'ReceiverCity',
  6. ra.PostCode AS 'ReceiverPostCode',
  7. ra.Street AS 'ReceiverStreet',
  8. ra.HouseNumber AS 'ReceiverHouseNumber',
  9. ra.ApartmentNumber AS 'ReceiverApartmentNumber'
  10. FROM Package, (Data r JOIN Address ra ON r.ID_address = ra.ID)
  11. WHERE Package.ID_receiver = r.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