Im tying to get some information from a database. The design is wery strange and there are no foreign keys, no constrains, how am I supposed to do correct joins? Some colums have the same data (in different tables), How can i assure that i get all the entries?
Looks like you have found every programmers nightmare with the database that you have.
From experience, I think it is just a case of plugging you way through the tables, hope that where columns are duplicated in tables that the column name is the same (or similar enough to be obvious), otherwise just trial and error.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.