Jump to content

GerardoH95

Members
  • Posts

    1
  • Joined

  • Last visited

Everything posted by GerardoH95

  1. Im currently following the SQL tutorial on w3schools and i got stuck in the Alias section about the usage of the "dot" in a query, after looking it on google i found that its something like a parent-child relation so that the DBMS know where to fetch the values from. However i feel that this example in the tutorial is too verbose: SELECT Orders.OrderID, Orders.OrderDate, Customers.CustomerNameFROM Customers, OrdersWHERE Customers.CustomerName="Around the Horn" AND Customers.CustomerID=Orders.CustomerID; And can be easily translated to this other one SELECT OrderID, OrderDate, CustomerName FROM Customers, Orders WHERE CustomerName="Around the Horn" AND Customers.CustomerID=Orders.CustomerID; it retrieves the same data in the practice tool, so i want to know if im doing a good practice by removing this redundancy or not. here is the link to the topic im talking about: https://www.w3schools.com/sql/sql_alias.asp
×
×
  • Create New...