Your SQL command was:
SELECT TOP 30 
s.plate,s.mjd,s.fiberid 
FROM ..SpecObj as s 
JOIN PhotoObj AS p ON s.bestobjid=p.objid 
WHERE  (p.i - p.z) > 3 AND (p.i - p.z) < 4 AND p.u > 0 

Your query output (max 500,000 rows):

platemjdfiberid
205253401343
725856605847
725856605673
725856605798
725856605970
125952931385
30751663257
474555892330
46851912282
384155572654
40075532790
420518717
33951692607
379255212527
47452000233
47652314323
728857039107
729456739339
728556991515
4435187389
731157038373
26775418099
731157038650
637756245947
727557093534
20535344655
731856990795
737856715291
35551788278
35151695574

Use the button below to upload the results of the above query to the SAS and from there click Search to download or view the spectra:

Upload list of spectra to SAS