I have Gone Through the Tutorial Provided in the Link. Now I am able to use LEFT JOIN to Merge Two Tables as per my Requirement. I am using this Command
Select A.FileName,A.InvoiceNo,A.Phoneno,A.N_month,A.Amtpayable,M.ExCHANGE,M.FIRSTNAME,M.LASTNAME,M.INSTALDATE FROM AMOUNTPAYABLE A LEFT JOIN MASTER M ON A.FileName=M.AccountNo
But Now I have another Table and yet another. In Such cases How will I now Add. Suppose I need Column PREVBALAMT From PREVBAL. PREVBAL has also the same common filed FIlename. What Would be the revised SQL For adding Multiple Tables.
>It works for me.
>
>>>>
>>>>
http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins>>>
>>>Good answer! This is a straightforward SQL issue. The original poster will learn a lot more from working out the command based on the information in the (excellent) link than he would from someone handing him the answer. If someone posts asking about a more advanced SQL feature, that's one thing, but IMO it does the poster no favors to serve up code for a basic task.
Harsh