Problem With Right Join - Microsoft Access / VBA

1 New Member

I am attempting to determine which of the following Program Cods(A) below are [U]not[/u] contained within the Program Tranlation Code Table (B) using the follwing SQL query:

SELECT DISTINCT [Untranslated Programs].[Untranslated Programs]
FROM Program_Transla tion RIGHT JOIN [Untranslated Programs] ON Program_Transla tion.ID = [Untranslated Programs].ID
WHERE ((([Untranslated Programs].[Untranslated Programs])<>"CC-P"));

The output of the query is listed below (C).
I used basically the same query for determining Product Lines(A1) not contained within an productline tranlation table(B1) and was successfull getting the correct output (C1). Please inform me wht I am not able to get the SQL uery to work for the program codes. Thank you for your assistance.
Viru

(A) Program Codes
00001WA000
0000GIS000
4002101
0008002671-fdavis
0133KA0H0A
0133KA0H1A
01M1140K1A
01MKTF0L0A
1L001L0000
5140514000
5180518000
5200526821
5230523000
7E223E2000
7SA0NSA000
CK10JK1000
DEB2DEB000
FE20FE2000
KE21CE2000
NEB0MEB000
NSA0MSA000

(B)Program Translation Code Table
00001WA000
0000GIS000
5006151
8001681
8002671
0008002671-fdavis
8003671
8005671
8005681
8006671
8008671
8008681
8100671
8100681
8200671
000PP10100
000PP10200
000PP10400
000PP10600
000PP10800
000PP20100
000PP40100
000PP40200
000PP40400
000PP50200
000PP51100
000PP60200
0080A3A32A
0080IR022A
0080IR032A
0106AN0M1A
0130TV0H0A
0133EN0H0A
0133KA0H0A
0133KA0H1A
01C7014P0C
01MKTF0L0A
01T1QM621A
4400440000
5000100100
5000100201
5000100203
5000200100
5000300100
5000400100
5000500100
5001200100
5001400100
5001500100
5001600100
5002200100
5002400100
5002500100
5002600100
5003200100
5003400100
5003500100
5003600100
5004200100
5004400100
5004500100
5004600100
5005200100
5005400100
5005500100
5100100100
5140514000
5200525821
5230523000
6200621741
6200621761
6200629841
7E223E2000
7SA0NSA000
CK10JK1000
CP20JP2000
DEB2DEB000
FE20FE2000
KE21CE2000
NEB0MEB000
NSA0MSA000

(C)Programs Never Translated
00001WA000
0000GIS000
4002101
0008002671-fdavis
0133KA0H0A
0133KA0H1A
01M1140K1A
01MKTF0L0A
1L001L0000
5140514000
5180518000
5200526821
5230523000
7E223E2000
7SA0NSA000
CK10JK1000
DEB2DEB000
FE20FE2000
KE21CE2000
NEB0MEB000
NSA0MSA000

(A1)Product Lines
Architeture Dsn Engr
Asset Mgmt Del Assur
Blank
CIVIL GROUP
Federal Srv Delivery
FIN & ADMINISTRATION
Global Solution & Technol
Managed Desktop Services

(B1)Product Line Translation Table
Asset Mgmt. & Delivery As
Asset Mgmt. & Delivery As
Asset Mgmt. & Delivery As
Fin & Bus Management
Fin & Bus Management
Fin & Bus Management
Glb Operations
Glb Operations
Glb Operations
Global Solution & Technol
Managed Comp Service
Managed Comp Service
Managed Comp Service
Managed Network Serv
Managed Network Serv
Managed Network Serv
New Bus Serv-Global
New Bus Serv-Global
New Bus Serv-Global
Service Delivery - US Fed
Service Delivery - US Fed
Service Delivery - US Fed
Srv Delivery America
Srv Delivery America
Srv Delivery America

(C1) Product Lines
Architeture Dsn Engr
Asset Mgmt Del Assur
Blank
CIVIL GROUP
Federal Srv Delivery
FIN & ADMINISTRATION
Global Solution & Technol
Managed Desktop Services

Oct 8 '06 #1

Subscribe Reply

1157

Similar topics

3328

using functions and file renaming problem

by: hokiegal99 | last post by:

A few questions about the following code. How would I "wrap" this in a function, and do I need to? Also, how can I make the code smart enough to realize that when a file has 2 or more bad charcters in it, that the code needs to run until all bad characters are gone? For example, if a file has the name "<bad*mac\file" the program has to run...

Python

4843

Right outer join problem

by: Omavlana | last post by:

Hi, I need your help to resolve this problem. I have written a right outer join query between 2 indipendent tables as follows. select b.Account_desc, b.Account, a.CSPL_CSPL from Actual_data_final a right outer join Actual_account_Tbl b on a.account_desc = b.account_desc where (a.source_type = 'TY02' or a.source_type is null) and...

Microsoft SQL Server

1535

Problem in Right Outer join query

by: Omavlana | last post by:

Microsoft SQL Server

4964

OUTER JOIN problem

by: Matt | last post by:

Hello I have to tables ar and arb, ar holds articles and a swedish description, arb holds descriptions in other languages. I want to retreive all articles that match a criteria from ar and also display their corresponding entries in arb, but if there is NO entry in arb I still want it to show up as NULL or something, so that I can get...

Microsoft SQL Server

5184

Problem executing a make table query in vb.net

by: Neil Robbins | last post by:

I am trying to execute a make table query in my vb.net program. The db that I am accessing is an Access 2000 format db. The SQL code that I am using has been cut and pasted from the SQL View having designed the query in the design view of Access. The code in question is below, I apologise for the length of the SQL statement Dim...

Visual Basic .NET

2177

Outer join problem

by: PW | last post by:

I've created an ASP application which uses an Access database. I've created an outer join query, but for some reason the "Property_Def" column is not aligning with the "ESPN" column. They should be aligned on the ESPI common columns. In this attached image, the first lines ESPI of 010471 "ADJUSTABILITY" which should line up with the...

ASP / Active Server Pages

3091

Performance problem with joins

by: imranpariyani | last post by:

Hi i have a severe performance problem with one of my views which has 6 to 8 joins .. any help will be appreciated.. the view is: CREATE OR REPLACE VIEW thsn.trade_view AS SELECT tra.tra_id, tra.per_id, tra.fir_id, tra.tra_dcn, tra.tra_startdate::date AS tra_startdate, tra.tra_enddate::date AS tra_enddate, tra.tra_highprice,...

PostgreSQL Database

12434

Select Count(*) problem

by: MP | last post by:

vb6,ado,mdb,win2k i pass the sql string to the .Execute method on the open connection to Table_Name(const) db table fwiw (the connection opened via class wrapper:) msConnString = "Data Source=" & msDbFilename moConn.Properties("Persist Security Info") = False moConn.ConnectionString = msConnString moConn.CursorLocation = adUseClient...

Microsoft Access / VBA

5746

Problem: Performance difference between MSDE and SQL Express 2005

by: HC | last post by:

Hello, all, I started out thinking my problems were elsewhere but as I have worked through this I have isolated my problem, currently, as a difference between MSDE and SQL Express 2005 (I'll just call it Express for simplicity). I have, to try to simplify things, put the exact same DB on two systems, one running MSDE and one running...

Microsoft SQL Server

3710

Problem with Set MyRst = MyDB.OpenRecordset(PString, dbOpenForwardOnly)

by: MLH | last post by:

Gentlemen: I am having one heck of a time taking a DAO walk through the records in an SQL dynaset. I'm trying to walk a set of records returned by a UNION query. I'm attempting to filter the records to those related to vehicle #60 ( = 60 ). If I explicitly specify 60 in the SQL ==everything works fine. Take a look: 100 PString = "SELECT ...

Microsoft Access / VBA

7664

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7583

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

8106

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7638

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

5484

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

3626

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2082

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1198

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

923

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General