Oops... should be:
SELECT Realtor.Name, PropType.Name
FROM Realtor, PropType
WHERE Realtor.RealtorID = RealtorAndPropType.RealtorID
AND RealtorAndPropType.PropTypeID = PropType.PropTypeID
Before you go any further, it would be wise to normalize your db design
Before you go any further, it would be wise to normalize your db design
each field in the db should be atomic - it should contain a single
value (not a list of values)...
Assuming your table is a realtor table, you need another table to
associate the list of realtors with the list of
Hi, All,
One of the fields (property.type)in my query contains a comma-delimited list
of numbers (1,3,4)
I have a lookup table (types) that consists of two fields: ID and Name.
Now, I need to replace numbers in Property.type with names from Type.Name.
How could that be done with ColdFusion?
3 matches
Mail list logo