I have a couple of tables I am working with that do not have very good
PK/FKs setup.
(Unfortunately this is not my schema and I don't have the luxury of changing
it)
1) Manufactures [ManID, ManName, ....]
2) Products [PID, ManID, RealManID ]
ManID and RealManID map to MID and usually contain differing values. I need
(hopefully) in one query to extract both the Real Manufacturer Name and the
other Manufacturer Name.
Duane
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
