Select Query Help !!!!!

[latitude800]

I have the following query that pulls a TermID Publication source. I am not getting any results, I get the Term ID but Publication source NULL. Please any suggestions. Thanks very much in advance.

SELECT gps.TermID, gps.PubSourceID, gpsr.PubSource,
FormattedPubSource=CASE WHEN gps.PubSourceID<>'' THEN '<i>Source Publication: </i>' END,
PubSourceBreak=CASE WHEN gps.PubSourceID<>'' THEN '<br>' END
FROM ispe_Glossary_PubSource gps
LEFT OUTER JOIN ispe_Glossary_PubSource_Ref gpsr
ON gps.PubSourceID=gpsr.PubSourceID
ORDER BY gps.TERMID

 

[philhege]

Do you have any records in gpsr which meet
the join condition
ON gps.PubSourceID=gpsr.PubSourceID ?

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Eschewing obfuscation diurnally.