sql request...

csl-telecom · ‎01-28-2003

Story short, I need to actually list the pickup lines numbers with the associated directory number.

Does someone knows what SQL query I could use to see this kind of information?

Thanks Alex.

s-doyle · ‎02-03-2003

You can try out something similar to this.

select dNOrPattern from numplan where ikNumPlan_CallPickupGroup in (select pkid from numplan where dnorpattern = xxxx)

Note: xxxx is the directory number.

ankur · ‎02-17-2003

can u email me the request to ankur@infozech.com (with details of fields required) - we should be able to help you with this.

Ankur