I'm hoping this will receive a wider audience here in Talk.
This is SQL for an Oracle 7 DBMS.
I need to join a fixed 21 character field that looks like
aTable.wwwwwwwxxxxxyyzzzzzzz where wwwwww = bTable.field1 AND xxxxx =
bTable.field2 AND yy = bTable.field3 AND zzzzzz = bTable.field4 unless
zzzzzz is 0 then wwwwwww = bTable.field 4.
Uhg.
I have this code, but I'm not sure what to do with it.
WITHOUT reg_firmno:
SELECT
pur.epa_registration_num,
prod.mfg_firmno,
prod.label_seq_no,
prod.revision_no,
prod.reg_firmno
FROM
pur89raw pur,
product prod
WHERE
(pur.chemical_code LIKE '%185' OR pur.chemical_code LIKE '%573') AND
cast(substr(pur.epa_registration_num,0,7) AS number(7)) =
prod.mfg_firmno AND
cast(substr(pur.epa_registration_num,8,5) AS number(5)) =
prod.label_seq_no AND
cast(substr(pur.epa_registration_num,13,2) AS char(2)) =
prod.revision_no AND
cast(substr(pur.epa_registration_num,0,7) AS number(7)) =
prod.reg_firmno
TIA
Ian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301103
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
