473,503 Members | 1,783 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

duplicate rows occurring when using inner join

1 New Member
duplicate rows occurring when using inner join,i want to join a table value to another table..
Feb 17 '15 #1
1 1513
ck9663
2,878 Recognized Expert Specialist
It either means one of the tables have duplicates or your JOIN condition is resulting to duplicate records.

It would also help if you post the code so we can take a look at it.

Good Luck!!!


~~ CK
Feb 17 '15 #2

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

Similar topics

0
8927
by: Jonathan Patton | last post by:
Hi,=20 I have a query that runs in Microsoft Access against my mysql database = just fine. It is:=20 =20 UPDATE discussion_categories AS discussion_categories_1=20 INNER JOIN...
0
1321
by: B. Fongo | last post by:
------=_NextPart_000_0007_01C36311.DEE8D2E0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello! I ' m trying to extra some information from 2 tables using...
4
23867
by: Nathan | last post by:
I have an application that uses an Access database to gather information on students' test scores. In the database there are three tables which are joined by one- to-many relationships: ...
5
32317
by: asgars | last post by:
i have two tables, tab1 having N1 col and tab2 N2 col. now N1 is subset of N2. I need the information from tab2 (having N2) of all rows having the matching entry in N1 in tab1. For this i am...
4
2228
exoskeleton
by: exoskeleton | last post by:
hi dear experts im here once again...i have a problem on showing the result when im using inner join...here's my code.. $sql_trans_pro_tbl="SELECT...
1
2081
by: chaitanya02 | last post by:
Hi,,, I have 2 tables in access: tblUrl (software Url, contract number- 2 columns) and tblAccContract(4 columns-accountid, contract id, contract date, email addr) I am querying these two...
3
2350
by: chaitanya02 | last post by:
I have problem joining four tables using Inner Join in ACCESS DB, I want to join 4 tables: 1, 2, 3 , 4 ....and query data in all these to see, i get a right url associated. sql1-account id,...
12
13156
by: Chamnap | last post by:
Hello, everyone I have one question about the standard join and inner join, which one is faster and more reliable? Can you recommend me to use? Please, explain me... Thanks Chamnap
4
1937
kcdoell
by: kcdoell | last post by:
Hello: I have a form that has 3 combo boxes. CboDivision cboWrkReg cboCreditReg In the Field Properties, of those combo boxes I used the “Default Value” to populate selections that were...
0
1568
by: Aditya jha | last post by:
Hi, I want to fetch data from DB2 using INNER JOIN with access file, Is it possible. If yes then how?.
0
7086
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...
1
6991
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...
0
7460
tracyyun
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...
0
5578
agi2029
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,...
0
4672
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...
0
3167
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...
0
1512
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 ...
1
736
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
380
bsmnconsultancy
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...

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.