Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

No foreign keys!

Status
Not open for further replies.

lene

Programmer
Mar 7, 2001
1
SE
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?
 
Hi Lene,

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.

Best of luck!!

Tim
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top