Let me know the difference between Joins and Aliases in the manner as shown:
string query1 = "Select P_Detail.Name,P_Detail.RollNo,MAC_TAb.Address,CellDetails.CellNo from P_Detail INNER JOIN MAC_TAb on P_Detail.ID=MAC_TAb.ID " + " INNER JOIN CellDetails on P_Detail.Name=CellDetails.Name";
string query2 = "Select P_Detail.Name,P_Detail.RollNo,MAC_TAb.Address,CellDetails.CellNo from P_Detail,MAC_TAb,CellDetails where P_Detail.ID=MAC_TAb.ID AND CellDetails.Name=P_Detail.Name ";
According to this i could notice that using query1 and query2 we use to get same result.
Then why do persons use joins instead of the simple query of aliases.
Go to the complete details ...