Advertisement
Guest User

Untitled

a guest
Mar 19th, 2019
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. Table1 table contains below columns with values:
  2. ValueOne = C11
  3. ValueTwo= C12
  4. ValueThree= C13
  5.  
  6. Table2 table contains below columns (extra id column compare to table1).
  7. Id = 123
  8. ValueOne = C11
  9. ValueTwo= V12
  10. ValueThree= C13
  11.  
  12. example: 1) Select * from ViewName where ID=123
  13. then in this case I will get below values:
  14. Id = 123
  15. ValueOne = C11
  16. ValueTwo= V12
  17. ValueThree= C13
  18.  
  19. 2) Select * from ViewName where ID=01
  20. in this case it has to get the below values:
  21. Id = 01
  22. ValueOne = C11
  23. ValueTwo= C12
  24. ValueThree= C13
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement