How to combine Two selected datas

Question

Iam selected two types of data from some tables.

My data is

Date OpenWt StWt ... etc

2011-05-13 00:00:00.000 -10.000 0.000 0.000 0.000 6.000 0.000 0 0 0 0
2011-05-13 00:00:00.000 -10.000 0.000 7.000 0.000 0.000 0.000 0 0 0 0

i want join this data by date, it is same date, join same date into one rows.

These date are different table date, say one is Sales bill date other one is purchase bill date.

Lastly if it is same date show only one row.. how possible?

my code is attached with this...

Vilas Gite · Answer

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

Sam Hobbs · Answer

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.

Suthish Nair · Answer

can you show how the o/p must looks like?