Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Table1 table contains below columns with values:
- ValueOne = C11
- ValueTwo= C12
- ValueThree= C13
- Table2 table contains below columns (extra id column compare to table1).
- Id = 123
- ValueOne = C11
- ValueTwo= V12
- ValueThree= C13
- example: 1) Select * from ViewName where ID=123
- then in this case I will get below values:
- Id = 123
- ValueOne = C11
- ValueTwo= V12
- ValueThree= C13
- 2) Select * from ViewName where ID=01
- in this case it has to get the below values:
- Id = 01
- ValueOne = C11
- ValueTwo= C12
- ValueThree= C13
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement