Guys,

Can anyone advise best possible way to execute: This is what I am looking to do............

A form textarea field that send multiple (lets assume 5) comparable numbers with the database to be displayed on the result page (like courier tracking)... Each of those five number may have additional number of rows!!

This is what I have:
Table 1: Only numbers (unique)
Table 2: Same numbers but with multiple records

I am looking to show results in

Unique Number 1 - (table 1)

Record 1 -(table 2)
Record 2
Record 3
Record 4

Unique Number 2 - (table 1)

Record 1 -(table 2)
Record 2
Record 3
Record 4

and so on..........

I tried using this query, but did not helped!!

check="select * from table1 p, table2 t where p.uniquenumber=t.uniquenumber and uniquenumber=split(i)"


Appreciate your help


have a nice day!!:)

>>> I'm not quite grasping the essence of your question, some example data may help <<<