Constraint Violating Yak Guru
quote:Originally posted by gbrittonWhat have you tried so far?Note that your "Step 2" doesn't make sense, since table 3 does not have a PropertyCode column.Also, Table 1 has PropertyCode as the second column, but your expected results shows values from the PropListID column instead.
Flowing Fount of Yak Knowledge
quote:Originally posted by DonAtWorkBut my homework needs done now! How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx