Two tables, want to run query to join them

grooner10 · #1 (**permalink**) 01-18-12, 12:52

Alright,

I have two tables one having first year premiums, and the other renewal premiums.

They both are sorted by bulkid which is common between them.

I want to run a query so i can get all the information from each table in one, but I can't run a union query as the table with first year premiums has less rows because not ever bulkid has first year premiums. Is it possible to make a query so that for bulkid's that don't have first year premiums it just shows up as zero?

thanks,

healdem · #2 (**permalink**) 01-18-12, 13:19

show us the table design
but in theory its going tobe something like

select my, column, list from mytable
join myothertable on myothertable.thatcolumn = mytable.thiscolumn

Sinndho · #3 (**permalink**) 01-18-12, 13:26

You can perform a UNION operation on two SELECT queries, one of them having a constant.

- Table1 has 6 columns: Col1, Col2, Col3, Col4, Col5, Col6
- Table2 has 5 columns: Col1, Col2, Col3, Col4, Col6
- Its possible to write a query such as:

Code:

SELECT Col1, Col2, Col3, Col4, Col5, Col6
  FROM Table1
UNION
SELECT Col1, Col2, Col3, Col4, 0, Col6
  FROM Table2

Internet Services

Web Development

Digital Marketing

Consumer Tech