Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

Extracting data from one table that is not in another table

Experts,

I am creating table10  From Table1.  However, I only want what is not in Table2 - Table9.  The unique key is claim. What would be the most efficient way to do this?
0
morinia
Asked:
morinia
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
try using a make table from a union query

select f1,f2,f3,f4
from table1 left join table2
on table1.claim=table2.claim
where table2.claim is null

union

select f1,f2,f3,f4
from table1 left join table3
on table1.claim=table3.claim
where table3.claim is null
union

...continue up to table9
0
 
PatHartmanCommented:
To continue Rey's thought.
After you create the union query, create a query that does a left join of table1 to the union.  Select only records where the key field in the union query is null.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now