Pramod Gupta

Pramod Gupta

  • 1.7k
  • 231
  • 31k

how to get output of below query using join

Dec 16 2018 6:52 AM
we have table table1
 
ID               Name
121               A    
121.1            B
122               C
121.2            D
121.3            E
122.1            F
122.2            G 
 
how to get below output by using joins
 
ID        id2
121      121.1
121      121.2
121      121.3
122      122.1
122      122.2 

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (2)