Let say I have a data table that list a name, ID for the last name, a
field linking it to another table, and a field listing if an optional
LinkStatus. I want to run a check to determine if each last name ID
has a Link to the external ID and exclude ones that have a linkstatus
value. Example:
Name ID LinkedToExtID LinkStatus
Smith, J 1 A24
Smith, H 1
Henry, B 2
Franks, D 3
Franks, E 3 A47
Franks, F 3
Rose, J 4
Rose, L 4
Rose, S 4
Jones, A 5 InProgress
Jones, H 5
Want to run a query returning
ID
2
4
because none of these IDs have a corresponding LinkedToExtID value or
any value in the LinkStatus field. IDs 1 and 3 have a LinkedToExtId
value and ID 5 has a status, so 2 and 4 are the only problems. After
several hours of trying things, I can't seem to get this one.
Any thoughts,
Andrew V. Romero 2 980
On Wed, 30 Apr 2008 15:23:02 -0700 (PDT), "rr*******@icqmail.com"
<rr*******@icqmail.comwrote:
If I understand correctly, you need:
select distinct ID from SomeTable
where LinkedToExtID is null and LinkStatus is null
-Tom.
>Let say I have a data table that list a name, ID for the last name, a field linking it to another table, and a field listing if an optional LinkStatus. I want to run a check to determine if each last name ID has a Link to the external ID and exclude ones that have a linkstatus value. Example:
Name ID LinkedToExtID LinkStatus Smith, J 1 A24 Smith, H 1 Henry, B 2 Franks, D 3 Franks, E 3 A47 Franks, F 3 Rose, J 4 Rose, L 4 Rose, S 4 Jones, A 5 InProgress Jones, H 5
Want to run a query returning ID 2 4 because none of these IDs have a corresponding LinkedToExtID value or any value in the LinkStatus field. IDs 1 and 3 have a LinkedToExtId value and ID 5 has a status, so 2 and 4 are the only problems. After several hours of trying things, I can't seem to get this one.
Any thoughts,
Andrew V. Romero
On Apr 30, 9:17*pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Wed, 30 Apr 2008 15:23:02 -0700 (PDT), "rrstud...@icqmail.com"
<rrstud...@icqmail.comwrote:
If I understand correctly, you need:
select distinct ID from SomeTable
* where LinkedToExtID is null and LinkStatus is null
Won't select distinct ID where the LinkedToExtId and LinkStatus is
null also return values like ID 3 since there are 2 rows with the ID
of 3 also have null LinkedToExtID and null Linkstatus fields? Since
there is one row with an ID of 3 that has a value in the
LinkedToExtID, I want to exclude it. Only looking for IDs that don't
have a value in the LinkedToExtID or LinkStatus in any of their
records.
Thanks,
Andrew V. Romero This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Wolfgang |
last post by:
I have a problem with linking my CPP Code under a irix6 machine (sgi,
UNIX). In my CPP code I use some Functions which are written in
Python. So its a kind of CPP wrapper for my Python functions In...
|
by: Dibyendu Roy |
last post by:
Hi All,
I build an object called "dblorcle" to connect to oracle database
in Sun solaris box. This is built linking with various oracle ".a"
(archived, for static linking) files come with standard...
|
by: Steven T. Hatton |
last post by:
Is there anything that gives a good description of how source code is
converted into a translation unit, then object code, and then linked. I'm
particularly interested in understanding why putting...
|
by: Steven T. Hatton |
last post by:
I just read this in the description of how C++ is supposed to be
implemented:
"All external object and function references are resolved. Library
components are linked to satisfy external...
|
by: gasturbtec |
last post by:
please help im new at access programming and i just got this project
dropped in my lap because the old programmer quit. i've been doing ok
so far but now i need to add code to an existing database...
|
by: Rudy Ray Moore |
last post by:
I work with a multi-project workspace. One project (the "startup" project)
has a "Configuration Type" of "Application (.exe)". The other 40 projects
have a "Configuration Type" of "Static Library...
|
by: Rudy Ray Moore |
last post by:
I've been having trouble getting incremental linking to work under Visual
C++ .net 2003 7.1 for my multi-project workspace. Ronald Laeremans and Carl
Daniel (and a few others) helped me figure it...
|
by: Philip Lowman |
last post by:
I am in the process of trying to migrate a couple of build solutions to
Visual Studio Express 2005 from VS 2003 Professional and I am running
into a weird C/C++ runtime library linking issue when...
|
by: srikar |
last post by:
what is the difference between static linking & dynamic linking,
what are the advantages of each?
How to perform static linking & Dynamic linking
by using gcc -o liniking will be done , but...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
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...
|
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...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
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...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
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
| |