I'm trying to create a view from two tables address and address_association.
So I did the following and expect they are the same:
CREATE VIEW associated_address AS
select t0.association_id AS association_id,
t0.property_dict AS property_dict,
t0.type_id AS type_id,
t0.owner_id AS owner_id,
I suspect that you actually have two records in address_association that
don't match up with a record in address. Yes, either a data mismatch or
data duplication would be suspected in a case like this.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Elim Qiu [EMAIL