Hi Everyone
I am having a problem with an SQL statement into an SQL89 Progress database. I have 4 fields in the database itmg_nm,sub1,sub2,sub3 that work together in a hierarchy for example table
GNRL HIN BUT AAA
GNRL HIN CLA AAA
GNRL MOO BBB CCC
HAND SAW
HAND WIC JJJ
HAND WIC PPP
The lower levels (sub1,sub2,sub3) do not always have a value. I want a select statement that would select from the above example only following records
GNRL HIN CLA AAA
GNRL MOO BBB CCC
HAND SAW
HAND WIC JJJ
Because I'm using SQL89, I can't seem too use any concatenating functions in the select statement. Has any one any ideas how a select statement could be written to extract only this information.
Thanks
Darren
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement