acctman Posted April 7, 2010 Share Posted April 7, 2010 Can someone explain the below statement to me with an example/sample... basically what i'm trying to do is handle a member couple profile which will have multiple Firstnames, Age, Height, etc about 10 fields will be similar. You could create duplicate fields, but simply add a single extra field, "coupleId", which would have a unique id for each couple; and two rows (one for each person) per couple; then JOIN the table against itself with a constraint like a.coupleId = b.coupleId AND a.id <> b.id so that you can condense the data into a single result row for a given couple. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 9, 2010 Share Posted April 9, 2010 Huh? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.