Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunrag77
Starting Member
8 Posts |
 Posted - 2009-07-29 : 07:05:59
|
| HiI have two tables oinv and orct. key relationship field is oinv.receiptnum = orct.docnum.In oinv there 5000 records. On that 5000, for only 2000 records receiptnum is there, balance 3000 there is no receipt num. I want to get the receipt date for that 2000 records in oinv records from orct.if i run the below query, its showing only the 2000 records which are having receipt number, balance 3000 records its not showing. How to get all the 5000 records with receipt date for the records having receiptnum.select oinv.docdate, oinv.docnum, oinv.receiptnum, orct.docdatefrom oinv inner join orct on oinv.receiptnum = orct.docnumpl help on this.RegardsSundaram |
|
|
Mangal Pardeshi
Posting Yak Master
110 Posts |
|
|
|
|
|
Regarding connecting 2 tables