Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have Data
order | item | sno | from | to |
0140000209 | 000010 | 0001 | 27-12-2019 | 02-01-2020 |
0140000209 | 000010 | 0002 | 15-01-2020 | 15-01-2020 |
0140000209 | 000010 | 0003 | 16-01-2020 | 16-01-2020 |
0140000209 | 000010 | 0004 | 19-02-2020 | 19-02-2020 |
Here Im Passing Order and Item and getting
0030000820|000010 |
0030000825|000010 |
below items
I just Join Table
Here Im Getting 8 Items Because 2*4
0140000209 | 000010 | 0001 | 27-12-2019 | 02-01-2020 | 0030000820|000010| |
0140000209 | 000010 | 0002 | 15-01-2020 | 15-01-2020 | 0030000820|000010| |
0140000209 | 000010 | 0003 | 16-01-2020 | 16-01-2020 | 0030000820|000010| |
0140000209 | 000010 | 0004 | 19-02-2020 | 19-02-2020 | 0030000820|000010| |
0140000209 | 000010 | 0001 | 27-12-2019 | 02-01-2020 | 0030000825|000010| |
0140000209 | 000010 | 0002 | 15-01-2020 | 15-01-2020 | 0030000825|000010| |
0140000209 | 000010 | 0003 | 16-01-2020 | 16-01-2020 | 0030000825|000010| |
0140000209 | 000010 | 0004 | 19-02-2020 | 19-02-2020 | 0030000825|000010| |
and in 2nd table also have from and to Date
from | to | |
0030000820|000010 | 27-12-2019 | 02-01-2020 |
0030000825|000010 | 16-01-2020 | 16-01-2020 |
I'm Expecting Output
order | item | sno | from | to | |
0140000209 | 000010 | 0001 | 27-12-2019 | 02-01-2020 | 0030000820|000010| |
0140000209 | 000010 | 0002 | 15-01-2020 | 15-01-2020 | |
0140000209 | 000010 | 0003 | 16-01-2020 | 16-01-2020 | 0030000825|000010| |
0140000209 | 000010 | 0004 | 19-02-2020 | 19-02-2020 |
How can I Archive This