Pulling non-Roman title from SRS or Inventory #494
todolson
started this conversation in
Discussions
Replies: 1 comment 2 replies
-
I'm sure there are a million ways to do this, but I think this is at least logical:
Basically, you can do the query for the Oh, and I have |
Beta Was this translation helpful? Give feedback.
2 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
For our Pull List report, I need to pull the non-Roman title of a work, or null if there is nothing. In MARC terms, this is identifying the 880 (just ‡a & ‡b) that corresponds to the 245 of a record. Here's a record that illustrates the complexity (HRID 2491042 in my system):
Stripping this down to relevant columns, this is stored in
srs_marctab
like so:I think what I want is (in mixed coding metaphor):
for a given HRID, identify the 880 where
sf
= 6 andcontent
matches245%
, and return the 880 fields with the sameord
wheresf
is in ("a", "b")What I have in SQL is:
This seems like there must be a better solution, especially because of the need to reference the
instance_hrid
value in both the outer select and the sub-select. And this will need to become part of another query in an MS Access application.Does anyone have any advice on how to improve this?
Beta Was this translation helpful? Give feedback.
All reactions