By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

Combining multiple columns into 1.

P: n/a
I have four columns in one table. I want to add all the records in each
of these columns into 1 column in another table. Any ideas??

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies

P: n/a
add how? you mean mathematically or append? How about 4 append
queries? Sounds like these designs are seriously dodgy. You might
benefit from a look at Michael Hernandez's Database Design for Mere

Nov 13 '05 #2

P: n/a
Hahahah....... indeed, they are exceptionally dodgy. If only work would
give me the time to actually learn how to do this all properly....

Nov 13 '05 #3

P: n/a
In that case, if you have only just started, you may well be better off
describing what your database is supposed to do before going further.
Because bad design makes your work later on MUCH more difficult. If
you design your database well, querying etc is easy (well, most of the
time!) If you do it wrong, then querying is well nigh impossible.

So, I hate to put you on the spot, but describe what this thing does...
What "things" are you keeping info about? How are they related? Once
you've nailed that down, what info do you want out of this thing?

Hope this points you in the right direction.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.