I did not really understand the benifit of the alias clause...
this was in the w3shools tatourial
with alias
SELECT po.OrderID, p.LastName, p.FirstName
FROM Persons AS p,
Product_Orders AS po
WHERE p.LastName='Hansen' AND p.FirstName='Ola'
with out alias
SELECT Product_Orders.OrderID, Persons.LastName, Persons.FirstName
FROM Persons,
Product_Orders
WHERE Persons.LastName='Hansen' AND Persons.FirstName='Ola'
why we just write it as smiple select statment like this
SELECT OrderID, LastName, FirstName
FROM Persons,Product_Orders
WHERE LastName='Hansen' AND FirstName='Ola'
can anyone help me to figer out the deffrence ?!! :S
btw anyone can leade me to a tutorial about nested SQL statements like Nested select etc...
or free oracle quiz