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:
SELECTOrders.OrderID, Orders.OrderDate, Customers.CustomerName FROMCustomers, Orders WHERECustomers.CustomerName="Around the Horn"ANDCustomers.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.
Question related to the "dot"usage in SQL
in SQL
Posted
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.CustomerName
FROM Customers, Orders
WHERE 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