Get data from 4 different tables
View Single Post
01-16-2008, 02:27 AM
Join Date: Jan 2008
Hi, thanks for the quick reply. I also looked at UNION, but the problem is, that it takes the fieldnames from the first select, and the fields from the admin table are totally different.
Second, I know that my database design sounds strange, but it's not. I have to do everything in a seperate table cause a company could have multiply departments sign up. So if I put it in 1 table I could end up with 5 times the same data of 1 company. And different companies could have the same departmentnames, so I could have more then once the same departmentname in the table.
And if I make it 1 table, it would have propaly 3 fields, and the 3 field would only be use for companies (department field). So that's not optimalisation.
I optimised my table to the Third normal form, or I did something wrong or it's just impossible for what I want.
View Public Profile
Send a private message to Ultimatum
Find More Posts by Ultimatum