Union riddle?

[jason]

What kind of results will a UNION query produce if you want to merge the
contents of two tables or queries which currently hold the following:

MktStatus

A 1 (long)
B 1(long)
C A1 (long)

PriceChange
B 100,000 (Currency)


If I unionize them, will it only return one record: eg B

Or will it return them ALL expect that two of the rows - A and C - will have
blank Price Change Fields?

Thanks
Jason

 

[Duane Hookom]

A UNION query would return 4 records:

A 1 (long)
B 1(long)
C A1 (long)
B 100,000 (Currency)

I believe you are referring to a standard JOIN in a query which can be set
up to return only matching records or all the records from one or the other
table.

 

[jason]

Yes - that is correct: I wish to combine the elements of two tables
according to any changes that have been made to the two tables.

If I find a date that matches each other I wish to join them. However, it is
slightly more complex as the date fld is small date time while the other is
just date.

There may be many small date times and I need to get the last one for that
day.

 

[Duane Hookom]

Formatting of a date/time field has no bearing on what is stored. BTW: I
didn't even see a date field in your sample data. Please provide a complete
description of your data and what you expect returned in your query.