SWAROOP P

SWAROOP P

  • NA
  • 175
  • 14k

How to get Records using below scenario.

May 30 2014 5:01 AM
Table1:
This is the table1 data it having IPNumber. It contain 50,000 Records.
 
Table2:
This is table2 data it having below columns like ip_from & ip_to. This table contain 2023184Recs.
Query:
I want to get the data from Table1 and Table2 based on condition that is IPNumber from Table1 check range
between Table2 ip_from, ip_to columns. How to get the data from above two table.
Please give any idea for above issue.

Answers (6)