This document was generated from CDN thread
Created by: Jeff Garner on 18-11-2009 07:26:51 PM
Does any one have a good SQL query to pull a listing of devices with the first DN, One query I have produces multiple listing of the same device for each DN, Ive tried using the DISTINCT command with lo luck on this query
SELECT FIRST 5 D.Name as name, D.description as desc, NP.dnorpattern as dn FROM NumPlan NP , DeviceNumPlanMap DNPMap, Device D where UPPER(D.Name) like 'SEP%' AND DNPMap.fkNumPlan = NP.pkid AND D.pkid = DNPMap.fkDevice;
I know there has to be a better way with a JOIN perhaps?
Subject: RE: SQL Query, Pull Device listing with 1st DN
Replied by: David Staudt on 18-11-2009 08:43:23 PM
If you are looking to return only the top line, try adding 'devicenumplanmap.numplanindex=1' to the WHERE clause
