Welcome! Please take a few seconds to create your free account to post threads, make some friends, remove a few ads while surfing and much more. ClutchFans has been bringing fans together to talk Houston Sports since 1996. Join us!
There might be a potential typo on the identifiers you're using on the "ON" statement. Can you check if "SPRIDENT_CURRENT_PERS_LAST_NAME" should...
You'll get a syntax error if you put a comma after the last column you're selecting. Take out the comma at the end of, "Select DISTINCT...
Try this: Select columns From SPRIDEN_CURRENT Inner Join SPRIDEN_PREVIOUS On SPRIDEN_CURRENT_PIDM = SPRIDEN_PREVIOUS_PIDM WHERE...
One more thing, I'm not sure what you're trying to accomplish with "WHERE pers_last_order<>last_order", but if "pers_last_order" is on one table...
If you need to learn on the fly, http://www.w3schools.com/sql/default.asp is a good reference tool as well.
That comma after "LAST" will throw an error. Can you include the error message if that doesn't solve it?
[SPOILER] Sean Bean, 'Game of Thrones' star, stabbed in bar brawl...
HBO GO is working for me now (through Comcast).
Apparently he refused the transfer:...
I've got a question... How do you think the states or feds could allocate funding and other resources if they don't have standardized testing to...
Teaching to the test is indeed bad, but who says critical reasoning and standardized testing must be mutually exclusive.
Before I go any further, I just want to preface by saying that I'm one of the lucky people that went to a good public school. I may not truly...
How do we hold our public schools accountable if we don't administer standardized tests to see if the students are actually learning? I...
<iframe title="YouTube video player" width="480" height="390" src="http://www.youtube.com/embed/xbsSeVr5NSI" frameborder="0" allowfullscreen></iframe>
<iframe title="YouTube video player" width="480" height="390" src="http://www.youtube.com/embed/e7MC6yseBGU" frameborder="0" allowfullscreen></iframe>
Mission Accomplished
