how to join on all five tables from database(what i mean is joining all the records, not joining the fields), sorting them(eg. sort by "total" in...

How It Works

Get an answer in three easy steps. Here's how it works...

1. Ask Your Question

Enter your programming question at the top of this page and click Get An Answer.

2. Pick Your Priority

Tell us how quickly you want your programming question answered.

3. Get An Answer

Connect with your programmer via online chat or telephone call.

Get An Answer

Answer

Customer

how to join on all five tables from database(what i mean is joining all the records, not joining the fields), sorting them(eg. sort by "total" in descending order) and then display the result...all the 5 tables have same field structure...please help me...thank you...

Posted 2/2/2002

gameover

Programmer

need more info dude

Posted 4/5/2002

dash

Programmer

It may not be a good idea. 1. create temp table as per one structure 2. insert all values to temp 3. do the processing on temp 4. delete temp table using program Can you do like this. It will be easier, rather than thinking of writing a lots of code.

Posted 4/23/2002

netguy

Programmer

Hey - Another easy way (If you do not want to create Temp tables and delete afterwards etc) is to create a view (If you are using SQL), then run your query against that view. For better performance, I recommend you use Stored Procedures. Hope this helps! Antonio Chagoury http://www.Mynetguy.com http://www.InspectorIT.com

Posted 6/22/2002

Get An Answer

Testimonials

Featured Programmer

Byron Narciso
Programmer

Byron has over 15 years of Technical Support Experience with expertise on Windows, Apple devices , Android, Virus Removal, Cloud Computing, Email Configuration, Smartphones, Facebook, Instagram, Kindle, Twitter,Dropbox, Linkedin, Printer configurations and Networking. He has worked for some of the top computer manufacturers in the world and has served as a Subject Matter Expert for Level 1 and 2 technicians providing assistance in resolving advance technical issues. Byron holds a degree in Electronics and Communications Engineering with a DSCE and CCNA certification.

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.

ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!

Get An Answer

how to join on all five tables from database(what i mean is joining all the records, not joining the fields), sorting them(eg. sort by "total" in...

How It Works

Get an answer in three easy steps. Here's how it works...

1. Ask Your Question

2. Pick Your Priority

3. Get An Answer

Answer

Testimonials

Featured Programmer

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

More Programming Questions...

Ask Your Programming Question & Get An Answer Now!