SQL Versions

AS / Table Alias

Access

SELECT Book.Isbn
  FROM tblBook AS Book

Oracle

SELECT BOOK.ISBN
  FROM BOOK

UPDATE

Access

    UPDATE tblOrder     AS Order
INNER JOIN tblBook      AS Book 
        ON Order.ItemId  = Book.Id          
       SET Order.Number  = Book.Isbn

Oracle

UPDATE ORDER            
   SET NUMBER      = ( SELECT ISBN FROM BOOK WHERE ORDER.ITEMID = BOOK.ID )
 WHERE        EXISTS ( SELECT ISBN FROM BOOK WHERE ORDER.ITEMID = BOOK.ID )