Get unique names from two tables

[rowanp]

I have two tables that contain a list of server names, and I need to show just the unique names from these tables. A server name can appear in both tables. I would also like to have the results editable in a form. The field name that I need it ServerName for both tables.

Thanks in advance,

Rowan.

 

[lespaul]

And if you just show unique names from both servers, exactly which table do you want to edit if it's in both tables?


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[rowanp]

So, I will create a new table to contain the results .. and use an append query to write the results. Right now, I have two queries that pulls this information from the different tables, using the distinct option and then append it..

So my question becomes this:
Is there any easy way to remove the data from my temp table, and to run both queries at the same time.

 

[PHV]

What about an UNION query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

PH, I didn't think a UNION query was updatable?

Leslie

 

[PHV]

Leslie, I've replied to the post stamped 18 Jan 07 9:44.

 

[lespaul]

So, I'm right, a UNION isn't updatable?

Leslie

 

[PHV]

You're right, a UNION ins'nt updatable, as a DISTINCT or a GROUP BY.
If you're really interested about updatable queries:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886