Asclepias
Diamond Member
You just exposed yourself There are no tables named Call Table in my statement. How many tables am I referencing with this statement?I can tell you didn't write that for pay.Dont stall. Tell the board what that statement does. Its fairly simple. I barely know SQL and I wrote that one myself.And do me a favor, use Proper case for your Table and Field Name.Tell me what this SQL statement does.I've never seen a Black programmer/developer.Wait youre a programmer and youre telling me you have never seen a Black programmer? Stop lying dude.
The H1-Bs took the jobs before the Blacks got in.
And I admit I don't consider IT Security Script monkeys to be programmers/developer.
The systems I build using include 100+ infrastructure tables and hundreds of code tables and perhaps a 100 or so entity tables.
I write SQL statements that can contain 15 or more tables with sub one second response.
So no, you're not a programmer.
run sql select first 20 call.extension as Ext, call.rtptnani as Rp_used_callback_sent_2_PSAP, call.erlname as ERL,erl.streetname as Street,erl.community as City, erl.statename as State, call.calltime as Time from cercallhistory as call inner join cererl as erl on erl.name=call.erlname order by call.calltime desc
I'd never let you even get away with a non-paragraphed statement.
It looks like you vomited on the screen.
First of all, please name the Call Table PhoneCall, not Call.
Call the Field Name Extension or PhoneNumberExtension so management can tell what it means.
The same for the rest.
Write code as though it's a document meant to be read by a Business Analyst.