11-11-2007 03:02 PM - edited 03-15-2019 04:56 AM
I have two tables dbo_device that holds the device info and table dbo_DeviceNumPlanMap that holds the line info for a device. I am trying to pull the e164mask info and associate with the device description info.
This is my query
SELECT dbo_Device.Name, dbo_Device.Description, dbo_DeviceNumPlanMap.Label, dbo_DeviceNumPlanMap.Display, dbo_DeviceNumPlanMap.E164Mask
FROM dbo_Device RIGHT JOIN dbo_DeviceNumPlanMap ON dbo_Device.ikDevice_DefaultProfile = dbo_DeviceNumPlanMap.fkDevice
WHERE (((dbo_DeviceNumPlanMap.E164Mask)='3175551212'));
The issue is I cant really find any fields between the two that coorolate. I found one field but that only match device profiles.
Is there another table I should be including to get the info I need?
11-12-2007 01:25 PM
You should also check NumPlan table (DeviceNumPlanMap.fkNumPlan = NumPlan.pkid)
E164 number you can get using deviceNumPlanMap.e164mask and numplan.dnorpattern fields
--
regards,
pk
11-12-2007 02:11 PM
I started playing with the SQl Database Diagram tool. I figured out when I included the Device table and the DeviceNumPlanMap table it did the diagram then I could look at the connecting line between the two tables. The properties of the connecting line showed me what fields matched. The Device - PKID field
DeviceNumPlanMap - fkDevice field
Matched
Hope this helps someone else!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide