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 |
|
nistala86
Starting Member
1 Post |
 Posted - 2014-02-12 : 01:55:51
|
| Hii created a view with a simple join querythere are 2 rows with orderid as null, i am unable to fetch the details when i give WHERE Condition as "select orderid from joins where orderid=NULL"Query :create view joins as select A.customerid,A.Companyname,A.Contactname,A.City,B.OrderId from Customers A left join orders Bon A.Customerid=B.Customeridkindly helpRegardsRamakrishna |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-02-12 : 03:11:46
|
[code]select orderid from joins orders where orderid IS NULL[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Unable to fetch Details