Jump to content

Archived

This topic is now archived and is closed to further replies.

Crimpage

SQL Joins

Recommended Posts

Hi All,

Anyways... I have to try and fix a MS Access report my boss actually PAID someone to do, and it runs like crap.

We have an Active table, and an Archive table, to make access to the data in the active table quicker.

When running reports tho, we need to add the results of the Active table to the results from the Archive table.

They have one query running on the active, and the same one running on the Archive table. It then uses a MS Access thing called a UNION SELECT, which pretty much just puts the results on top of each other to make 1 recordset.

Is there a type of join that can do this? UPPER JOIN sounds like a good name for one... thats what I would call it if I made it...

By the way, I'm not using PHP for (Although I would like to...)

Cheers,

David.

Share this post


Link to post
Share on other sites
In a word, No.

JOINS take data from related records and aggregate the related columns of data in to single row.

In this case, UNION is the way to do it.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.