How to combine Two selected datas

hi Abdu

 here one is good article for joins in SQL server of Raj kumar member of our Mindcracker, please check it, hopes it will solve your problem. 

http://www.c-sharpcorner.com/UploadFile/raj1979/SqlJoins10012008164642PM/SqlJoins.aspx

 

There are many details that need to be specified. One very important one is whether the sales and purchase records are all in the same table or are they in separate tables? Is there just one record of each type (such as one sale and one purchase) per date?

I am not as experienced with SQL as many others here, but the problem is if all records are in one table. Perhaps it is possible to join records from the same table but using a select of the record type. Or probably you could have select statements to select records and do a join of those.

In another thread John Penn said "joining to a subquery" and that might be what you need here too. If so then either he or Suthish or someone else will be a long to help you with that but you neeed to provide more information before they can help you.