SQL is proof that Satan walks amongst us

[LynneSin]

discuss!

[meegbear]

1. SELECT * FROM TheDamned

[no name no slogan]

2. SQL whips a llama's ass

I just took an all-day SQL class on Tuesday. I used to have a passing animosity towards it, but now I'm outer joining like a badass mofo.

Plus it's hella better than the candy-assed query language running on my main system. I'd KILL to have SQL support on it.

[Louis C. Phurye]

3. Who? What? I did what...?

Sorry, a little bit groggy, just woke up.

[I Have A Dream]

4. So does getting JavaScript code to display correctly on multiple browsers.

Must have been inspired by Satan himself! :(

(I don't know much SQL so I'll trust you on that one!)

[DS1]

5. Better than that crap Access hackery

:P

update users set status = "Mute" where username = "LynneSin";

done.

[LynneSin]

8. I truly believe that you are Satan

and to think you were allowed back into our lil slice of heaven

:eyes:

[no name no slogan]

21. Agreed. Access eats a big bowl of crap.

GIVE ME PARADOX OR GIVE ME DEATH


(btw, how'd you get away with the buttsecks owl in your sigline? :rofl: )

[NewJeffCT]

6. I thought it was that PowerPoint was proof?

I knew a woman that messed up a big presentation due to her lack of skills at PowerPoint... so, a year or so later, when she left the company, I had found a little cartoon that had Satan at a desk interviewing somebody saying, "We need somebody well versed in the art of torture" and then next panel was Satan following up with, "Do you know PowerPoint?" And, I gave it to her.

She was at the point where she could laugh about those sorts of things, though...

[hippiechick]

7. ... completely agree!

:mad: It's been taunting me for weeks at work !!! :nuke:

[LSK]

9. left join left join left join

[mainegreen]

10. Soul sucking stuff. I offer this snoozefest as proof:

SELECT
C_EVENT.INT_EVENT_ID,
C_EVENT.DTE_INJURY,
C_EVENT.TIME_INJURY,
C_EVENT.DTE_EMPLOYER_NOTIFIED,
C_EVENT.DTE_INSURER_NOTIFIED,
C_EVENT.TXT_EVENT_DESC,
C_EVENT.BLN_EVENT_ON_PREMISIS,
C_EVENT.TXT_ADDR1 AS TXT_EVENT_ADDR1,
C_EVENT.TXT_ADDR2 AS TXT_EVENT_ADDR2,
C_EVENT.TXT_ADDR3 AS TXT_EVENT_ADDR3,
C_EVENT.TXT_CITY AS TXT_EVENT_CITY,
C_EVENT.TXT_COUNTY AS TXT_EVENT_COUNTY,
EVENT_STATES.TXT_STATE_DESC AS TXT_EVENT_STATE_DESC,
EVENT_STATES.TXT_STATE_SCODE AS TXT_EVENT_STATE_SCODE,
C_EVENT.TXT_COUNTRY AS TXT_EVENT_COUNTRY,
C_EVENT.TXT_ZIP_5 AS TXT_EVENT_ZIP_5,
C_EVENT.TXT_ZIP_4 AS TXT_EVENT_ZIP_4,
C_EVENT.TXT_ZIP_INTL AS TXT_EVENT_ZIP_INTL,
C_EVENT.BLN_FATALITY,

C_CLAIM.INT_CLAIM_ID,
L_CLAIM_TYPE.TXT_CLAIM_TYPE_DESC,
L_CLAIM_TYPE.TXT_CLAIM_TYPE_SCODE,
JURISDICTION_STATES.TXT_STATE_DESC AS TXT_JURISDICTION_STATE_DESC,
JURISDICTION_STATES.TXT_STATE_SCODE AS TXT_JURISDICTION_STATE_SCODE,
C_CLAIM.DTE_EMP_RETURNED_TO_WORK,
C_CLAIM.DTE_INCAPACITY,
C_CLAIM.TXT_CLAIM_NUMBER,
C_CLAIM.TXT_WCB_NUMBER,
C_CLAIM.DTE_OPEN,
C_CLAIM.DTE_CLOSE,
C_CLAIM.DTE_FIRST_OUT_OF_WORK,
C_CLAIM.DTE_FIRST_RETURN_TO_WORK,
C_CLAIM.BLN_SUBROGATION,
C_CLAIM.TXT_TPI_NAME_FIRST,
C_CLAIM.TXT_TPI_MI,
C_CLAIM.TXT_TPI_NAME_LAST,
trim(concat(trim(concat(C_CLAIM.TXT_TPI_NAME_FIRST,concat(' ',C_CLAIM.TXT_TPI_MI))),concat(' ',C_CLAIM.TXT_TPI_NAME_LAST))) AS TXT_TPI_NAME_FULL,
C_CLAIM.TXT_TPI_ADDR1,
C_CLAIM.TXT_TPI_ADDR2,
C_CLAIM.TXT_TPI_ADDR3,
C_CLAIM.TXT_TPI_CITY,
C_CLAIM.TXT_TPI_COUNTY,
TPI_STATES.TXT_STATE_DESC AS TXT_TPI_STATE_DESC,
TPI_STATES.TXT_STATE_SCODE AS TXT_TPI_STATE_SCODE,
C_CLAIM.TXT_TPI_COUNTRY,
C_CLAIM.TXT_TPI_ZIP_5,
C_CLAIM.TXT_TPI_ZIP_4,
C_CLAIM.TXT_TPI_ZIP_INTL,
L_CLAIM_STATUS.TXT_CLAIM_STATUS_DESC,
L_CLAIM_STATUS.TXT_CLAIM_STATUS_SCODE,
L_CLAIM_STATUS.BLN_CLOSE_RESERVES,
C_CLAIM.BLN_APPORTIONMENT,
C_CLAIM.BLN_ACTIVE_LIEN,
C_CLAIM.BLN_CONCURRENT_EMPLOYER,
C_CLAIM.TXT_CE_NAME,
C_CLAIM.TXT_CE_ADDR1,
C_CLAIM.TXT_CE_ADDR2,
C_CLAIM.TXT_CE_ADDR3,
C_CLAIM.TXT_CE_CITY,
C_CLAIM.TXT_CE_COUNTY,
CE_STATES.TXT_STATE_DESC AS TXT_CE_STATE_DESC,
CE_STATES.TXT_STATE_SCODE AS TXT_CE_STATE_SCODE,
C_CLAIM.TXT_CE_COUNTRY,
C_CLAIM.TXT_CE_ZIP_5,
C_CLAIM.TXT_CE_ZIP_4,
C_CLAIM.TXT_CE_ZIP_INTL,
C_CLAIM.BLN_CONFIDENTIAL_CLAIM,
L_BODY_PART_SUB.TXT_BODY_PART_SUB_DESC,
L_BODY_PART_SUB.TXT_BODY_PART_SUB_SCODE,
L_BODY_PART.TXT_BODY_PART_DESC,
L_BODY_PART.TXT_BODY_PART_SCODE,
L_CAUSE_CODE_SUB.TXT_CAUSE_CODE_SUB_DESC,
L_CAUSE_CODE_SUB.TXT_CAUSE_CODE_SUB_SCODE,
L_CAUSE_CODE.TXT_CAUSE_CODE_DESC,
L_CAUSE_CODE.TXT_CAUSE_CODE_SCODE,
L_NATURE_INJURY_SUB.TXT_NATURE_INJURY_SUB_DESC,
L_NATURE_INJURY_SUB.TXT_NATURE_INJURY_SUB_SCODE,
L_NATURE_INJURY.TXT_NATURE_INJURY_DESC,
L_NATURE_INJURY.TXT_NATURE_INJURY_SCODE,
L_LOSS_CONDITION.TXT_LOSS_CONDITION_SCODE,
L_LOSS_CONDITION.TXT_LOSS_CONDITION_DESC,
L_ACCIDENT_TYPE.TXT_ACCIDENT_TYPE_DESC,
L_ACCIDENT_TYPE.TXT_ACCIDENT_TYPE_SCODE,
L_SEVERITY.TXT_SEVERITY_DESC,
L_SEVERITY.TXT_SEVERITY_SCODE,
L_NCCI_COVERAGE.TXT_NCCI_COVERAGE_DESC AS TXT_CLAIM_NCCI_COVERAGE_DESC,
L_NCCI_COVERAGE.TXT_NCCI_COVERAGE_SCODE AS TXT_CLAIM_NCCI_COVERAGE_SCODE,
L_NCCI_CLASS.TXT_NCCI_DESC AS TXT_CLAIM_NCCI_DESC,
L_NCCI_CLASS.TXT_NCCI_SCODE AS TXT_CLAIM_NCCI_SCODE,
L_LOCATION_TYPE.TXT_LOCATION_TYPE_DESC,
L_LOCATION_TYPE.TXT_LOCATION_TYPE_SCODE,
L_LOCATION_TYPE_SUB.TXT_LOCATION_TYPE_SUB_DESC,
L_LOCATION_TYPE_SUB.TXT_LOCATION_TYPE_SUB_SCODE,
L_LOSS_TYPE.TXT_LOSS_TYPE_DESC,
L_LOSS_TYPE.TXT_LOSS_TYPE_SCODE,
C_CLAIM.BLN_EXCESS_REPORTING,
USER_ADJ.TXT_NAME_LAST AS TXT_ADJUSTER_NAME_LAST,
USER_ADJ.TXT_NAME_FIRST AS TXT_ADJUSTER_NAME_FIRST,
USER_ADJ.TXT_NAME_MI AS TXT_ADJUSTER_NAME_MI,
trim(concat(trim(concat(USER_ADJ.TXT_NAME_FIRST,concat(' ',USER_ADJ.TXT_NAME_MI))),concat(' ',USER_ADJ.TXT_NAME_LAST))) AS TXT_ADJUSTER_NAME_FULL,
USER_ADJ.TXT_ADDR1 AS TXT_ADJUSTER_ADDR1,
USER_ADJ.TXT_ADDR2 AS TXT_ADJUSTER_ADDR2,
USER_ADJ.TXT_ADDR3 AS TXT_ADJUSTER_ADDR3,
USER_ADJ.TXT_CITY AS TXT_ADJUSTER_CITY,
ADJUSTER_STATES.TXT_STATE_DESC AS TXT_ADJUSTER_STATE_DESC,
ADJUSTER_STATES.TXT_STATE_SCODE AS TXT_ADJUSTER_STATE_SCODE,
USER_ADJ.TXT_ZIP_5 AS TXT_ADJUSTER_ZIP_5,
USER_ADJ.TXT_ZIP_4 AS TXT_ADJUSTER_ZIP_4,
USER_ADJ.TXT_PHONE AS TXT_ADJUSTER_PHONE,
USER_ADJ.TXT_TITLE_FULL AS TXT_ADJUSTER_TITLE,
USER_ADJ.TXT_EMAIL AS TXT_ADJUSTER_EMAIL,
USER_SUP.TXT_NAME_LAST AS TXT_SUPPORT_NAME_LAST,
USER_SUP.TXT_NAME_FIRST AS TXT_SUPPORT_NAME_FIRST,
USER_SUP.TXT_NAME_MI AS TXT_SUPPORT_NAME_MI,
trim(concat(trim(concat(USER_SUP.TXT_NAME_FIRST,concat(' ',USER_SUP.TXT_NAME_MI))),concat(' ',USER_SUP.TXT_NAME_LAST))) AS TXT_SUPPORT_NAME_FULL,
USER_SUP.TXT_ADDR1 AS TXT_SUPPORT_ADDR1,
USER_SUP.TXT_ADDR2 AS TXT_SUPPORT_ADDR2,
USER_SUP.TXT_ADDR3 AS TXT_SUPPORT_ADDR3,
USER_SUP.TXT_CITY AS TXT_SUPPORT_CITY,
SUPPORT_STATES.TXT_STATE_DESC AS TXT_SUPPORT_STATE_DESC,
SUPPORT_STATES.TXT_STATE_SCODE AS TXT_SUPPORT_STATE_SCODE,
USER_SUP.TXT_ZIP_5 AS TXT_SUPPORT_ZIP_5,
USER_SUP.TXT_ZIP_4 AS TXT_SUPPORT_ZIP_4,
USER_SUP.TXT_PHONE AS TXT_SUPPORT_PHONE,
USER_SUP.TXT_TITLE_FULL AS TXT_SUPPORT_TITLE,
USER_SUP.TXT_EMAIL AS TXT_SUPPORT_EMAIL,
USER_SPR.TXT_NAME_LAST AS TXT_SUPERVISOR_NAME_LAST,
USER_SPR.TXT_NAME_FIRST AS TXT_SUPERVISOR_NAME_FIRST,
USER_SPR.TXT_NAME_MI AS TXT_SUPERVISOR_NAME_MI,
trim(concat(trim(concat(USER_SPR.TXT_NAME_FIRST,concat(' ',USER_SPR.TXT_NAME_MI))),concat(' ',USER_SPR.TXT_NAME_LAST))) AS TXT_SUPERVISOR_NAME_FULL,
USER_SPR.TXT_ADDR1 AS TXT_SUPERVISOR_ADDR1,
USER_SPR.TXT_ADDR2 AS TXT_SUPERVISOR_ADDR2,
USER_SPR.TXT_ADDR3 AS TXT_SUPERVISOR_ADDR3,
USER_SPR.TXT_CITY AS TXT_SUPERVISOR_CITY,
SUPERVISOR_STATES.TXT_STATE_DESC AS TXT_SUPERVISOR_STATE_DESC,
SUPERVISOR_STATES.TXT_STATE_SCODE AS TXT_SUPERVISOR_STATE_SCODE,
USER_SPR.TXT_ZIP_5 AS TXT_SUPERVISOR_ZIP_5,
USER_SPR.TXT_ZIP_4 AS TXT_SUPERVISOR_ZIP_4,
USER_SPR.TXT_PHONE AS TXT_SUPERVISOR_PHONE,
USER_SPR.TXT_TITLE_FULL AS TXT_SUPERVISOR_TITLE,
USER_SPR.TXT_EMAIL AS TXT_SUPERVISOR_EMAIL,

C_EVENT_PERSON.INT_PERSON_ID,
C_EVENT_PERSON.TXT_TITLE AS TXT_CLAIMANT_TITLE,
C_EVENT_PERSON.TXT_NAME_FIRST AS TXT_CLAIMANT_NAME_FIRST,
C_EVENT_PERSON.TXT_NAME_MI AS TXT_CLAIMANT_NAME_MI,
C_EVENT_PERSON.TXT_NAME_LAST AS TXT_CLAIMANT_NAME_LAST,
C_EVENT_PERSON.TXT_SUFFIX AS TXT_CLAIMANT_SUFFIX,
trim(concat(trim(concat(C_EVENT_PERSON.TXT_NAME_FIRST,concat(' ',C_EVENT_PERSON.TXT_NAME_MI))),concat(' ',C_EVENT_PERSON.TXT_NAME_LAST))) AS TXT_CLAIMANT_NAME_FULL,
C_EVENT_PERSON.TXT_SSN AS TXT_CLAIMANT_SSN,
C_EVENT_PERSON.TXT_ALTERNATE_ID AS TXT_CLAIMANT_ALTERNATE_ID,
L_EMPLOYEE_TYPE.TXT_EMPLOYEE_TYPE_SCODE AS TXT_CLAIMANT_EMPLOYEE_TYPE_SCODE,
C_EVENT_PERSON.TXT_ADDR1 AS TXT_CLAIMANT_ADDR1,
C_EVENT_PERSON.TXT_ADDR2 AS TXT_CLAIMANT_ADDR2,
C_EVENT_PERSON.TXT_ADDR3 AS TXT_CLAIMANT_ADDR3,
C_EVENT_PERSON.TXT_CITY AS TXT_CLAIMANT_CITY,
C_EVENT_PERSON.TXT_COUNTY AS TXT_CLAIMANT_COUNTY,
CLAIMANT_STATES.TXT_STATE_DESC AS TXT_CLAIMANT_STATE_DESC,
CLAIMANT_STATES.TXT_STATE_SCODE AS TXT_CLAIMANT_STATE_SCODE,
C_EVENT_PERSON.TXT_COUNTRY AS TXT_CLAIMANT_COUNTRY,
C_EVENT_PERSON.TXT_ZIP_5 AS TXT_CLAIMANT_ZIP_5,
C_EVENT_PERSON.TXT_ZIP_4 AS TXT_CLAIMANT_ZIP_4,
C_EVENT_PERSON.TXT_ZIP_INTL AS TXT_CLAIMANT_ZIP_INTL,
C_EVENT_PERSON.TXT_PHONE AS TXT_CLAIMANT_PHONE,
C_EVENT_PERSON.TXT_WORK_PHONE AS TXT_CLAIMANT_WORK_PHONE,
C_EVENT_PERSON.TXT_WORK_EXT AS TXT_CLAIMANT_WORK_EXT,
C_EVENT_PERSON.TXT_CELL_PHONE AS TXT_CLAIMANT_CELL_PHONE,
C_EVENT_PERSON.TXT_EMAIL AS TXT_CLAIMANT_EMAIL,
C_EVENT_PERSON.DTE_BIRTH,
C_EVENT_PERSON.DTE_DEATH,
L_GENDER.TXT_GENDER_DESC,
L_GENDER.TXT_GENDER_SCODE,
L_MARRIAGE.TXT_MARRIAGE_DESC,
L_MARRIAGE.TXT_MARRIAGE_SCODE,
DTE_HIRE,
DTE_FIRE,
L_EMPLOYMENT_STATUS.TXT_EMPLOYMENT_STATUS_DESC,
L_EMPLOYMENT_STATUS.TXT_EMPLOYMENT_STATUS_SCODE,
TXT_OCCUPATION,
L_POSITION.TXT_POSITION_DESC,
L_POSITION.TXT_POSITION_SCODE,
INT_WORK_HOURS_PER_WEEK,
FLT_WORK_HOURLY_RATE,
FLT_SALARY,
C_EVENT_PERSON.BLN_SURGERY,
C_EVENT_PERSON.INT_PERMANENT_IMPAIRMENT_RATING,
C_EVENT_PERSON.DTE_MAX_MED_IMPROVEMENT,

E_SELECT_E.INT_MEMBER_ID,
E_SELECT.INT_COMPANY_ID,
E_SELECT_E.INT_LV2_ID,
E_SELECT_E.INT_LV3_ID,
E_SELECT_E.INT_LV4_ID,
E_SELECT_E.INT_LV5_ID,
E_SELECT_E.INT_LV6_ID,
E_SELECT_E.INT_LV7_ID,
E_SELECT_E.TXT_MEMBER_NAME,
E_SELECT.TXT_MEMBER_NAME AS TXT_COMPANY_NAME,

E_SELECT.TXT_MEMBER_SCODE AS TXT_COMPANY_SCODE,
L_MEMBER_TYPE.TXT_MEMBER_TYPE_DESC AS TXT_COMPANY_TYPE_DESC,
L_MEMBER_TYPE.TXT_MEMBER_TYPE_SCODE AS TXT_COMPANY_TYPE_SCODE,
E_SELECT.TXT_ADDR1 AS TXT_COMPANY_ADDR1,
E_SELECT.TXT_ADDR2 AS TXT_COMPANY_ADDR2,
E_SELECT.TXT_ADDR3 AS TXT_COMPANY_ADDR3,
E_SELECT.TXT_CITY AS TXT_COMPANY_CITY,
E_SELECT.TXT_COUNTY AS TXT_COMPANY_COUNTY,
MEMBER_STATES.TXT_STATE_DESC AS TXT_COMPANY_STATE_DESC,
MEMBER_STATES.TXT_STATE_SCODE AS TXT_COMPANY_STATE_SCODE,
E_SELECT.TXT_COUNTRY AS TXT_COMPANY_COUNTRY,
E_SELECT.TXT_ZIP_5 AS TXT_COMPANY_ZIP_5,
E_SELECT.TXT_ZIP_4 AS TXT_COMPANY_ZIP_4,
E_SELECT.TXT_ZIP_INTL AS TXT_COMPANY_ZIP_INTL,
E_SELECT.TXT_PHONE AS TXT_COMPANY_PHONE,
E_SELECT.TXT_FAX AS TXT_COMPANY_FAX,
E_SELECT.TXT_URL AS TXT_COMPANY_URL,
E_SELECT.TXT_FEID_ID AS TXT_COMPANY_FEID_ID,
L_NCCI_VENDOR.TXT_NCCI_DESC AS TXT_COMPANY_NCCI_DESC,
L_NCCI_VENDOR.TXT_NCCI_SCODE AS TXT_COMPANY_NCCI_SCODE,
L_BUSINESS_TYPE.TXT_BUSINESS_TYPE_DESC AS TXT_COMPANY_BUSINESS_TYPE_DESC,
L_BUSINESS_TYPE.TXT_BUSINESS_TYPE_SCODE AS TXT_COMPANY_BUSINESS_TYPE_SCODE,

E_SELECT_E.TXT_MEMBER_SCODE,
L_MEMBER_TYPE_E.TXT_MEMBER_TYPE_DESC,
L_MEMBER_TYPE_E.TXT_MEMBER_TYPE_SCODE,
E_SELECT_E.TXT_ADDR1 AS TXT_MEMBER_ADDR1,
E_SELECT_E.TXT_ADDR2 AS TXT_MEMBER_ADDR2,
E_SELECT_E.TXT_ADDR3 AS TXT_MEMBER_ADDR3,
E_SELECT_E.TXT_CITY AS TXT_MEMBER_CITY,
E_SELECT_E.TXT_COUNTY AS TXT_MEMBER_COUNTY,
MEMBER_STATES_E.TXT_STATE_DESC AS TXT_MEMBER_STATE_DESC,
MEMBER_STATES_E.TXT_STATE_SCODE AS TXT_MEMBER_STATE_SCODE,
E_SELECT_E.TXT_COUNTRY AS TXT_MEMBER_COUNTRY,
E_SELECT_E.TXT_ZIP_5 AS TXT_MEMBER_ZIP_5,
E_SELECT_E.TXT_ZIP_4 AS TXT_MEMBER_ZIP_4,
E_SELECT_E.TXT_ZIP_INTL AS TXT_MEMBER_ZIP_INTL,
E_SELECT_E.TXT_PHONE AS TXT_MEMBER_PHONE,
E_SELECT_E.TXT_FAX AS TXT_MEMBER_FAX,
E_SELECT_E.TXT_URL AS TXT_MEMBER_URL,
E_SELECT_E.TXT_FEID_ID AS TXT_MEMBER_FEID_ID,
L_NCCI_VENDOR_E.TXT_NCCI_DESC AS TXT_MEMBER_NCCI_DESC,
L_NCCI_VENDOR_E.TXT_NCCI_SCODE AS TXT_MEMBER_NCCI_SCODE,
L_BUSINESS_TYPE_E.TXT_BUSINESS_TYPE_DESC,
L_BUSINESS_TYPE_E.TXT_BUSINESS_TYPE_SCODE,
E_MEMBER_SUP.TXT_UIAN_NUMBER,
E_MEMBER_SUP.TXT_UIAN_SITE_NUMBER,
E_MEMBER_SUP.TXT_EMG,
E_MEMBER_SUP.TXT_EMMC,
E_MEMBER_SUP.TXT_EMPLOYER_DEPT,

E_VENDOR.INT_VENDOR_ID,
E_VENDOR.TXT_VENDOR_NAME,
E_VENDOR.TXT_VENDOR_SCODE,
E_VENDOR.BLN_1099,
E_VENDOR.TXT_TAX_ID,
E_VENDOR.TXT_PHONE,
E_VENDOR.TXT_FAX,
E_VENDOR.TXT_URL,
E_VENDOR.TXT_TAX_SSN,
L_NCCI_INS.TXT_NCCI_DESC AS TXT_VENDOR_NCCI_DESC,
L_NCCI_INS.TXT_NCCI_SCODE AS TXT_VENDOR_NCCI_SCODE,
E_VENDOR_LOCATION.INT_LOCATION_ID,
E_VENDOR_LOCATION.TXT_LOCATION_NAME AS TXT_VENDOR_LOCATION_NAME,
E_VENDOR_LOCATION.TXT_ADDR1 AS TXT_VENDOR_LOCATION_ADDR1,
E_VENDOR_LOCATION.TXT_ADDR2 AS TXT_VENDOR_LOCATION_ADDR2,
E_VENDOR_LOCATION.TXT_ADDR3 AS TXT_VENDOR_LOCATION_ADDR3,
E_VENDOR_LOCATION.TXT_CITY AS TXT_VENDOR_LOCATION_CITY,
E_VENDOR_LOCATION.TXT_COUNTY TXT_VENDOR_LOCATION_COUNTY,
VENDOR_STATES.TXT_STATE_DESC AS TXT_VENDOR_LOCATION_STATE_DESC,
VENDOR_STATES.TXT_STATE_SCODE AS TXT_VENDOR_LOCATION_STATE_SCODE,
E_VENDOR_LOCATION.TXT_COUNTRY AS TXT_VENDOR_LOCATION_COUNTRY,
E_VENDOR_LOCATION.TXT_ZIP_5 AS TXT_VENDOR_LOCATION_ZIP_5,
E_VENDOR_LOCATION.TXT_ZIP_4 AS TXT_VENDOR_LOCATION_ZIP_4,
E_VENDOR_LOCATION.TXT_ZIP_INTL AS TXT_VENDOR_LOCATION_ZIP_INTL,
E_VENDOR_LOCATION.TXT_PHONE AS TXT_VENDOR_LOCATION_PHONE,
E_VENDOR_LOCATION.TXT_FAX AS TXT_VENDOR_LOCATION_FAX,
E_VENDOR_SUP.TXT_INSURER_TYPE_CODE,

C_EVENT.INT_POLICY_ID,
C_EVENT.INT_MEMBER_POLICY_ID,
E_POLICY_VENDOR.INT_BANK_ACCOUNT_ID,
E_POLICY_VENDOR.TXT_POLICY_SCODE,
E_POLICY_VENDOR.TXT_POLICY_DESC,
E_POLICY_MEMBER.DTE_EFFECTIVE,
IFNULL(E_POLICY_MEMBER.DTE_TERMED,E_POLICY_VENDOR.DTE_TERMED) AS DTE_TERMED,
L_PROGRAM_TYPE.TXT_PROGRAM_TYPE_DESC,
L_PROGRAM_TYPE.TXT_PROGRAM_TYPE_SCODE,
L_COVERAGE_TYPE.TXT_COVERAGE_TYPE_DESC,
L_COVERAGE_TYPE.TXT_COVERAGE_TYPE_SCODE,
L_INDEX_BEAURAU.TXT_INDEX_BEAURAU_DESC,
L_INDEX_BEAURAU.TXT_INDEX_BEAURAU_SCODE,
E_POLICY_VENDOR.BLN_IS_EXCESS,
E_POLICY_VENDOR.BLN_HAS_EXCESS,
E_POLICY_VENDOR.FLT_SIR,
E_POLICY_VENDOR.INT_EXCESS_POLICY_ID

FROM C_EVENT
INNER JOIN C_CLAIM ON C_EVENT.INT_EVENT_ID=C_CLAIM.INT_EVENT_ID
LEFT OUTER JOIN L_STATES AS EVENT_STATES ON C_EVENT.INT_STATE_ID=EVENT_STATES.INT_STATE_ID
LEFT OUTER JOIN L_ACCIDENT_TYPE ON C_CLAIM.INT_ACCIDENT_TYPE_ID=L_ACCIDENT_TYPE.INT_ACCIDENT_TYPE_ID
LEFT OUTER JOIN L_LOSS_TYPE ON C_CLAIM.INT_LOSS_TYPE_ID=L_LOSS_TYPE.INT_LOSS_TYPE_ID
INNER JOIN C_EVENT_PERSON ON C_CLAIM.INT_CLAIM_ID=C_EVENT_PERSON.INT_CLAIM_ID
LEFT OUTER JOIN L_STATES AS CLAIMANT_STATES ON C_EVENT_PERSON.INT_STATE_ID=CLAIMANT_STATES.INT_STATE_ID
LEFT OUTER JOIN L_GENDER ON C_EVENT_PERSON.INT_GENDER_ID=L_GENDER.INT_GENDER_ID
LEFT OUTER JOIN L_MARRIAGE ON C_EVENT_PERSON.INT_MARRIAGE_ID=L_MARRIAGE.INT_MARRIAGE_ID
LEFT OUTER JOIN L_EMPLOYMENT_STATUS ON C_EVENT_PERSON.INT_EMPLOYMENT_STATUS_ID=L_EMPLOYMENT_STATUS.INT_EMPLOYMENT_STATUS_ID
LEFT OUTER JOIN L_POSITION ON C_EVENT_PERSON.INT_POSITION_ID=L_POSITION.INT_POSITION_ID
LEFT OUTER JOIN L_PERSON_TYPE ON C_EVENT_PERSON.INT_PERSON_TYPE_ID=L_PERSON_TYPE.INT_PERSON_TYPE_ID
INNER JOIN E_MEMBER ON C_EVENT.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID
INNER JOIN L_MEMBER_TYPE ON E_SELECT.INT_MEMBER_TYPE_ID=L_MEMBER_TYPE.INT_MEMBER_TYPE_ID
INNER JOIN L_MEMBER_TYPE AS L_MEMBER_TYPE_E ON E_SELECT_E.INT_MEMBER_TYPE_ID=L_MEMBER_TYPE_E.INT_MEMBER_TYPE_ID
INNER JOIN E_MEMBER_SUP ON E_SELECT_E.INT_MEMBER_ID=E_MEMBER_SUP.INT_MEMBER_ID
LEFT OUTER JOIN L_STATES AS MEMBER_STATES ON E_SELECT.INT_STATE_ID=MEMBER_STATES.INT_STATE_ID
LEFT OUTER JOIN L_STATES AS MEMBER_STATES_E ON E_SELECT_E.INT_STATE_ID=MEMBER_STATES_E.INT_STATE_ID
LEFT OUTER JOIN L_NCCI_VENDOR ON E_SELECT.INT_NCCI_ID=L_NCCI_VENDOR.INT_NCCI_ID
LEFT OUTER JOIN L_NCCI_VENDOR AS L_NCCI_VENDOR_E ON E_SELECT_E.INT_NCCI_ID=L_NCCI_VENDOR_E.INT_NCCI_ID
LEFT OUTER JOIN L_BUSINESS_TYPE ON E_SELECT.INT_BUSINESS_TYPE_ID=L_BUSINESS_TYPE.INT_BUSINESS_TYPE_ID
LEFT OUTER JOIN L_BUSINESS_TYPE AS L_BUSINESS_TYPE_E ON E_SELECT_E.INT_BUSINESS_TYPE_ID=L_BUSINESS_TYPE_E.INT_BUSINESS_TYPE_ID
INNER JOIN E_POLICY_VENDOR ON C_EVENT.INT_POLICY_ID=E_POLICY_VENDOR.INT_POLICY_ID
INNER JOIN E_VENDOR ON E_POLICY_VENDOR.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID
INNER JOIN E_VENDOR_SUP ON E_VENDOR.INT_VENDOR_ID=E_VENDOR_SUP.INT_VENDOR_ID
LEFT OUTER JOIN E_VENDOR_LOCATION ON E_VENDOR.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID
LEFT OUTER JOIN L_STATES AS VENDOR_STATES ON E_VENDOR_LOCATION.INT_STATE_ID=VENDOR_STATES.INT_STATE_ID
LEFT OUTER JOIN L_NCCI_VENDOR AS L_NCCI_INS ON E_VENDOR.INT_NCCI_ID=L_NCCI_INS.INT_NCCI_ID
INNER JOIN E_POLICY_MEMBER ON C_EVENT.INT_MEMBER_POLICY_ID=E_POLICY_MEMBER.INT_MEMBER_POLICY_ID
LEFT OUTER JOIN L_PROGRAM_TYPE ON E_POLICY_VENDOR.INT_PROGRAM_TYPE=L_PROGRAM_TYPE.INT_PROGRAM_TYPE
LEFT OUTER JOIN L_COVERAGE_TYPE ON E_POLICY_VENDOR.INT_COVERAGE_TYPE_ID=L_COVERAGE_TYPE.INT_COVERAGE_TYPE_ID
LEFT OUTER JOIN L_INDEX_BEAURAU ON E_POLICY_VENDOR.INT_INDEX_BEAURAU_ID=L_INDEX_BEAURAU.INT_INDEX_BEAURAU_ID
LEFT OUTER JOIN L_CLAIM_TYPE ON C_CLAIM.INT_CLAIM_TYPE_ID=L_CLAIM_TYPE.INT_CLAIM_TYPE_ID
LEFT OUTER JOIN L_STATES AS JURISDICTION_STATES ON C_CLAIM.INT_JURISDICTION_ID=JURISDICTION_STATES.INT_STATE_ID
LEFT OUTER JOIN L_STATES AS TPI_STATES ON C_CLAIM.INT_TPI_STATE_ID=TPI_STATES.INT_STATE_ID
LEFT OUTER JOIN L_CLAIM_STATUS ON C_CLAIM.INT_CLAIM_STATUS_ID=L_CLAIM_STATUS.INT_CLAIM_STATUS_ID
LEFT OUTER JOIN L_STATES AS CE_STATES ON C_CLAIM.INT_CE_STATE_ID=CE_STATES.INT_STATE_ID
LEFT OUTER JOIN L_BODY_PART_SUB ON C_CLAIM.INT_BODY_PART_SUB_ID=L_BODY_PART_SUB.INT_BODY_PART_SUB_ID
LEFT OUTER JOIN L_BODY_PART ON L_BODY_PART_SUB.INT_BODY_PART_ID=L_BODY_PART.INT_BODY_PART_ID
LEFT OUTER JOIN L_CAUSE_CODE_SUB ON C_CLAIM.INT_CAUSE_CODE_SUB_ID=L_CAUSE_CODE_SUB.INT_CAUSE_CODE_SUB_ID
LEFT OUTER JOIN L_CAUSE_CODE ON L_CAUSE_CODE_SUB.INT_CAUSE_CODE_ID=L_CAUSE_CODE.INT_CAUSE_CODE_ID
LEFT OUTER JOIN L_NATURE_INJURY_SUB ON C_CLAIM.INT_NATURE_INJURY_SUB_ID=L_NATURE_INJURY_SUB.INT_NATURE_INJURY_SUB_ID
LEFT OUTER JOIN L_NATURE_INJURY ON L_NATURE_INJURY_SUB.INT_NATURE_INJURY_ID=L_NATURE_INJURY.INT_NATURE_INJURY_ID
LEFT OUTER JOIN L_LOSS_CONDITION ON C_CLAIM.INT_LOSS_CONDITION_ID=L_LOSS_CONDITION.INT_LOSS_CONDITION_ID
LEFT OUTER JOIN L_SEVERITY ON C_CLAIM.INT_SEVERITY_ID=L_SEVERITY.INT_SEVERITY_ID
LEFT OUTER JOIN L_NCCI_CLASS ON C_CLAIM.INT_NCCI_ID=L_NCCI_CLASS.INT_NCCI_ID
LEFT OUTER JOIN L_NCCI_COVERAGE ON C_CLAIM.INT_NCCI_COVERAGE_ID=L_NCCI_COVERAGE.INT_NCCI_COVERAGE_ID
LEFT OUTER JOIN L_LOCATION_TYPE_SUB ON C_CLAIM.INT_LOCATION_TYPE_SUB_ID=L_LOCATION_TYPE_SUB.INT_LOCATION_TYPE_SUB_ID
LEFT OUTER JOIN L_LOCATION_TYPE ON C_CLAIM.INT_LOCATION_TYPE_ID=L_LOCATION_TYPE.INT_LOCATION_TYPE_ID
LEFT OUTER JOIN FW_USER AS USER_ADJ ON C_CLAIM.INT_ADJUSTER_ID=USER_ADJ.INT_USER_ID
LEFT OUTER JOIN FW_USER AS USER_SUP ON C_CLAIM.INT_ADJUSTER_ID=USER_SUP.INT_USER_ID
LEFT OUTER JOIN FW_USER AS USER_SPR ON C_CLAIM.INT_ADJUSTER_ID=USER_SPR.INT_USER_ID
LEFT OUTER JOIN L_STATES AS ADJUSTER_STATES ON USER_ADJ.INT_STATE_ID=ADJUSTER_STATES.INT_STATE_ID
LEFT OUTER JOIN L_STATES AS SUPPORT_STATES ON USER_SUP.INT_STATE_ID=SUPPORT_STATES.INT_STATE_ID
LEFT OUTER JOIN L_STATES AS SUPERVISOR_STATES ON USER_SPR.INT_STATE_ID=SUPERVISOR_STATES.INT_STATE_ID
LEFT OUTER JOIN L_EMPLOYEE_TYPE ON C_EVENT_PERSON.INT_EMPLOYEE_TYPE_ID=L_EMPLOYEE_TYPE.INT_EMPLOYEE_TYPE_ID

[DS1]

11. don't blame the SQL

that's just a poorly designed application

[mainegreen]

14. It's part of an interface to a state governent system.

You should see the insane documentation.
:boring:

Still, nothing will ever top the database I once saw that had a table called boolean. There were two rows. Can you guess what the values in those two rows were?

[LSK]

16. a table called boolean????

:rofl:

[DS1]

18. oh god no

did it have an index field as well? because, 1 or 2 would be insufficient :crazy:

[LSK]

12. holy crap thats a lot of joins

How long does that take to run????

Also why dont you rename your tables?

select a.fieldone, b.fieldtwo from tableone a left join tabletwo b on a.fieldthree = b.fieldfour

[mainegreen]

13. about .003 seconds

Left out the where clause and the indexes are good.

[LSK]

15. what database is it???

[mainegreen]

20. Sadly, it's running on MySQL5.

A buggy database server if there ever was one, but people *love* the price: free.
Me? I'd rather run on Oracle.

I'd alias the table names, but with a query that length readability was a higher priority. Still, it's ugly and nasty and it's all the governments fault that monstrosity exists!

[DS1]

22. I'm in the same boat

Our software runs MySQL, but I'd jump for joy if we ever converted to Oracle.

MySQL's backup system BLOWS!

[mainegreen]

23. mysqldump for me pulls the views down in alpha order....

but the damned views dependencies on each other are not in alpha order. So the view creation for half of them on restore fails.

Whoops.
You get what you pay for!

[RetroLounge]

17. SQL is Evil...

and used by the dark side of the force...

RL

[LynneSin]

19. I heard the inventor of SQL was the person they modeled Emperor Palpatine after