Union Query - Select on One Field Criteria but show all fields

[CJ]

Hi
Can any see where I'm going wrong I have 2 tables joined in a Union Query when I put in all the fields I want (No Dups) I get Duplicates because of DQ errors is mainly in the address I.E. Adress 5 can be England, Great Britain or UK !!! Nightmare

So I want to just select on one field [OrderNumber] but get the query to show the whole line for that record. is this possible ?

I'm using this:

SELECT [OrdersMar10.OrderNumber],OrdersMar10.*
FROM [OrdersMar10]

UNION SELECT [OrdersApr10.OrderNumber],OrdersApr10.*
FROM [OrdersApril10]
ORDER BY [OrderNumber];

Thanks !!

 

[Gettingbetter]

Hey CJ,

Not really an Excel question this, its a SQL question ha ha, but that being said,

There are a few ways to do this, about 5 diff ways on this page

http://stackoverflow.com/questions/251278/select-one-column-distinct-sql

Pick your fave,

Cheers
GB

 

[jackd]

Hi
Can any see where I'm going wrong I have 2 tables joined in a Union Query when I put in all the fields I want (No Dups) I get Duplicates because of DQ errors is mainly in the address I.E. Adress 5 can be England, Great Britain or UK !!! Nightmare

So I want to just select on one field [OrderNumber] but get the query to show the whole line for that record. is this possible ?

I'm using this:

SELECT [OrdersMar10.OrderNumber],OrdersMar10.*
FROM [OrdersMar10]

UNION SELECT [OrdersApr10.OrderNumber],OrdersApr10.*
FROM [OrdersApril10]
ORDER BY [OrderNumber];

Thanks !!

"So I want to just select on one field [OrderNumber] but get the query to show the whole line for that record. is this possible ?"

The SELECT statement shows the values for fields that you request.

SELECT fld1, fld2 FROM myTable ----will show fld1 and fld2
SELECT * FROM myTable--------------will show all fields

See http://www.w3schools.com/sql/sql_select.asp for SELECT statement syntax
See http://www.w3schools.com/sql/sql_union.asp for UNION syntax