MySQL Forums
Forum List  »  PHP

Re: Query Help - Duplicate Records
Posted by: Christopher Wibberley
Date: November 22, 2016 03:40AM

Hi Peter,

I see what you mean - thanks for taking the time to write all of that. The reason I decided to keep everything in a single table was because we will be serving thousands of customers, each with their own table, so I thought it would keep things simple. Looks like I was wrong and I'll need to rethink the structure before I can get any further with this.

Your query is using a few things I've never seen before (join, "as f") so I'll be checking this out further. Thank you though for the completed query, that is going to be really helpful.

Chris.

Options: ReplyQuote


Subject
Written By
Posted
Re: Query Help - Duplicate Records
November 22, 2016 03:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.