Thanks! These responses were really helpful. The queries are almost working...
The problem is that every legislator needs a record for every bill. This query runs once for the first legID in the list, then stops because there aren't any null comp_key values anymore.
I need to somehow test...
I'm not sure if this is possible or not - I might be hoping for magic :)
I have a database that receives new records every morning. I'd like to update a companion table with default information about these new records.
The database tracks legislation - every morning, after the new bills have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.