CREATE VIEW vwCOMPLETE_INFO AS SELECT (CUSTOMERS.FIRST_NAME || CUSTOMERS.LAST_NAME AS FULL_NAME), CUSTOMERS.AGE, CITIES.NAME FROM CITIES JOIN CUSTOMERS ON CUSTOMER.CITY_ID = CITY.ID;
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
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!