473,324 Members | 2,535 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

One to Many Relationship Between Columns

I have 2 columns within the table GROUPMAP,the data is shown as below -
ENDPOINTGROUPKEY NODEKEY
1103 1251
1103 1252
1103 1254
1103 1255
1103 1256
1103 1257
1103 1258
1103 1259
1103 1260
1102 1261
1102 1262
1102 1263
1102 1264
1102 1265
1103 1157
1103 1160
1103 1154
1103 1051
1103 1206
1103 1101
2001 1101
2001 1206
2001 1261
2001 1051
2001 1259
One NODEKEY can belong to more than one ENDPOINTGROUPKEY. Eg. NODEKEY 1051 which belongs to ENDPOINTGROUPKEY 1103 as well as 2001.

I want to retrieve unique node keys which DO NOT belong to ENDPOINTGROUPKEY 2001.
Can someone help ?
Mar 1 '10 #1
2 2475
rski
700 Expert 512MB
Expand|Select|Wrap|Line Numbers
  1. select distinct nodekey from GROUPMAP where nodekey not in
  2. (select nodekey from GROUPMAP where ENDPOINTGROUPKEY=2001)
  3.  
Mar 2 '10 #2
Thanks for your help. That worked. I was making the query complex, the above simple logic did not strike.

Thanks much!
Mar 2 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: Bob C. | last post by:
I want to create a 1-many relationship. Parent table has a primary key, child table has no primary key. The child table does have an index with all four fields of the parent's PK. How can I do...
4
by: Apple | last post by:
I have to create a query with many to many relationship, but I can't break it into 2 x 1 to many, should there anyone can teach me how to solve this problem. Thanks in advance!
3
by: lorirobn | last post by:
Hello, I have a report which uses a subreport. When I run the report, I get "Enter Parameter Value" error message for "tblGuestRoom". I click ok and the report seems to work fine. I...
1
by: Michael D. Reed | last post by:
I have two tables in an Access database with a Many-to-Many relationship, there is a connection table. The tables are , , and the connection table is this is a standard Many-to-Many relationship...
11
by: RobertJohn | last post by:
Hi all I am using Access 2007 to start a small home library application, and so far it has two tables. 1. Books, with fields Book_ID (Primary Key) and Title, and 2. Authors, with fields...
2
by: paulcjcross | last post by:
How to set up a many to many relationship. I know you need a third table to join the other two. I need one table (table1) with stock_numbers(unique), one table (table2) with job-numbers(unique) and...
6
by: BD | last post by:
Hi, all. I need to enforce a one-to-many relationship on 2 tables, with a join table. Say the join table contains account information. It has cust_no and acct_no. Both cust_no and acct_no are...
0
by: drhoades66 | last post by:
I have books, authors and a bkauthlink table linking the other two tables-a many-to-many relationship. I have tried various things but cannot create a Data Relation. Is there no way to do this in...
6
by: NicoleCartrette | last post by:
Going back to school is easier said than done.. This was posted to an older thread earlier but I don't think it got any attention. Your help is appreciated Professor requires we create a...
11
by: Mo Ewing | last post by:
I have one table called "Plants" that has a many-to-many relationship with a table called "Locations" through a third table called "PlantsToLocations". This setup works fine. I have a form where I...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.