Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions
. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum
. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!
SQL HALP Exists/Not Exists
Please help H/A. My code isn't working and I'm having a bit of a brainfart. Here's what I am trying to do:
I want to identify all the SOMETHING_NUMs that we have from an external feed that don't have corresponding object_ids on our internal table. object_ids are a 9 character string in the middle of SOMETHING_NUM.
What am I fucking up?
FROM db2..internal_tbl1 di,
SUBSTRING(SOMETHING_NUM,3,9) = di.object_id)