I have the following SP:
CREATE PROCEDURE [n_speaker_list] AS
SELECT DISTINCT s.f_name, s.l_name, s.pro_title, c.co_name, sm.subject,
a.agenda_title, s.sp_file
FROM speakers s, company c, subject_matter sm, agenda a
WHERE a.time_slot = s.time_slot
AND s.subject_id = sm.subject_id
AND s.company_id = c.company_id
AND s.sp_file is not null
ORDER BY s.f_name, s.l_name
I want to pull all records where the s.f_name and s.l_name are distinct but not the
rest of the string.
Can someone please enlighten me on how to do this?
Thanks,
Tim Bahlke
Tim Bahlke
----------------------------------------------------------------------------
Access your e-mail anywhere, at any time.
Get your FREE BellSouth Web Mail account today!
http://webmail.bellsouth.net
----------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
