I am not certain if I set this up correctly - all help would be appreciated:
SELECT [MASTER EOG].ACCOUNTID, [MASTER EOG].PUBCODE, [MASTER EOG].NAME, [MASTER EOG].PIATYPE, [MASTER EOG].FOD, [MASTER EOG].SUBSLNGTH, [MASTER EOG].RATECODE, [MASTER EOG].CURRENTBAL, [MASTER EOG].EOGDATE, [MASTER EOG].TELEPHONE, [MASTER EOG].ASSIGNDATE
FROM [MASTER EOG] As t1 LEFT JOIN [CLC REPORTS] As t2
ON t1.ACCOUNTID = t2.ACCOUNTID, ON t1.PUBCODE = t2.PubCode, ON t1.NAME = t2.Name, ON t1.RATECODE = t2.RateCode, ON t1.EOGDATE = t2.EOGDate, ON t1.TELEPHONE = t2.Telephone
1 2365 Rabbit 12,516
Recognized Expert Moderator MVP
A few things are wrong with it. Why not set up the query in design view and then look at the SQL?
1) If you use an alias, it must be used throughout. Which you didn't do for the fields you wanted to include.
2) Joining on multiple fields is represented through the AND operator and not through a comma.
3) You don't repeat the ON keyword.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Stijn Goris |
last post by:
I get an error when trying to insert a new row:
query error- 5 - Duplicate entry '80.200.213.102 Mozilla/4.0 (compatible;
MSIE 6.0; Windows NT 5.1; Avant Browser ; MyIE2; .NET CLR
1.0.' for key 1
The table consist of timestamp, file, level, ip, naam , ID
Where ID is an autoincrement, unique key.
Someone has an idea what going wrong?
|
by: Jim Hatfield |
last post by:
I'm using: "select min(objid) from table_name where objid > $objid"
to select the next row in a sequence where there may be gaps. It
works fine unless the where clause results in an empty set.
From the command line, a value is *always* returned, which is NULL
when the set of rows selected by the where clause is empty. I wasn't
sure what I expected mysql_query to return. I didn't expect a FALSE
result, since the query is syntactically...
|
by: Craig Stadler |
last post by:
Im trying to write a like query
select * from table1 where column1 like 'abc%'
(I realize this syntax isnt correct)
I want to include any chars from 0-9 in that spot...
Does anyone know how to do this?
-Craig
cstadler18@hotmail.com
|
by: Spartanicus |
last post by:
How to get help from this group, and how to construct a minimised test
case: http://www.spartanicus.utvinternet.ie/help_us_help_you.htm
--
Spartanicus
|
by: vips |
last post by:
Page_Load
datagrid1.datasource=dataset1
//I am filling the datagrid and it works fine when page is displayed
end
---------------
| |
by: Ramesh Dodamani |
last post by:
Environment:
XP Pro, VS.Net 2003, .Net 1.1.4322 with SP1 & KB Hotfix 886903
P4 2.2GHz, 1 GB RAM
My system was working fine till a few weeks back when I started seeing the
following errors.
"aspnet_wp.exe (PID: xxxx) stopped unexpectedly"
I am seeing the this error currently happen, but unlike the description in
articles Q823409 or 821387, I am not downloading any large file .The error
|
by: arnuld |
last post by:
in C++ Primer 4/3 Lippman says in chapter 3, section 3.3.1:
vector<stringsvec(10);
// 10 elements, each an empty string
here is the the code output & output from my Debian box running "gcc
3.3.5":
#include <iostream>
#include <vector>
|
by: imtmub |
last post by:
Hi,
I have a access database for simple accounts. I want to run the query from my excel sheet and get the result to that respective cells.
My database contains accounts name, type, credit limit, account receivable and account payable.
I can run the query to get any account details from access.
But i need that my manager don;t wana enter into database and run qry and he need get the details in excel sheet.
I had created the excel sheet....
|
by: artteam |
last post by:
we are having a sql query error when we are trying to update values from the datagridview to access database. The problem is because of date(because of its format), a runtime error pops up saying that "missing operator in query expression "to_date(2/2/2007 12:00:00 AM, "mm/dd/yy")"
we are only interested in date portion and not the time.
this our command string
cmd = "update Inventory Set itemDescription=" +...
|
by: ranesmitas |
last post by:
Hi ,I am using Visual Basic Backend SQL
I create form in which i create Command button
NEW ,MODIFY, VIEW,SAVE,EXIT
all my programme is running but when i add new record and save and then
i press VIEW button it gives error
i.e Object VAriable or with block variable not set
my code is
Private Sub Command1_Click() ' Add New Record
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| | |