hi,
how can i delete data from one table which is similar to another data in another table having same coloumn name.
suppose i have one table name test1 and another table named test2 .
test1 has columns let take one,two,three and test2 has same column as well.
Then i am able to compare the data which is similar to both tables in particular column.The thing i want to do is ::
"i want to delete the data which i found similar from one of the table"
How can i do this?
please reply.......... ....
1  3418 
hi,
how can i delete data from one table which is similar to another data in another table having same coloumn name.
suppose i have one table name test1 and another table named test2 .
test1 has columns let take one,two,three and test2 has same column as well.
Then i am able to compare the data which is similar to both tables in particular column.The thing i want to do is ::
"i want to delete the data which i found similar from one of the table"
How can i do this?
please reply.......... ....
Hi,
Try below Query -
DELETE FROM test1 WHERE column1 IN (SELECT column1 FROM test2)
-
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Nathan Bloom |
last post by:
Hi,
I have a data entry form (access 2000) that also allows the user to add,
update, and delete records from the form. The Delete action is carried out
in an event procedure and has the following code:
Private Sub Command28_Click()
On Error GoTo Err_Command28_Click
|
by: Emmett Power |
last post by:
Hi,
I have an Access table with a number of records which refer to the
same person but with data in different fields. So for example the
table would look like this:
Name..............Field 1...................Field 2
Fred Smith........Red
John Brown........Blue
Fred Smith...................................Truck
|
by: shandra |
last post by:
I have a file I need to delete or truncate. I tried using the KILL
command in VB6. I tried using the file.delete command in VB.net. I
tried manually deleting, renaming, and copying over the file... but
nothing works.
I keep getting the error: Cannot delete access_log: it is being used by
another person or program.
I tried shutting down services, I tried killing processes using the
task manager, I tried rebooting, and still, I get...
|
by: Zak McGregor |
last post by:
Hi all
I have a table, for simplicity's sake containing one field, called unid.
for example, select unid, oid from table gives me something like this:
unid | oid
---------+---------
|
by: Manish |
last post by:
The topic is related to MySQL database.
Suppose a table "address" contains the following records
-------------------------------------------------------
| name | address | phone |
-------------------------------------------------------
| mr x | 8th lane | 124364 |
| mr x | 6th lane | 435783 |
| mrs x | 6th lane | 435783 |
| | |
by: write2ashokkumar |
last post by:
hi...
i have the table values with duplicate records, i want to delete the duplicate records, How to delete the duplicate records? I need the query to delete the duplicate rows
Example:
id ---- name
1 ---- xxxx
2 ---- yyyy
|
by: theaybaras |
last post by:
Hi All,
I am creating a databse of articles and related information. I need to find a way to prevent the user from inputting duplicate information in a few forms.
In one of these forms I can just set my table not to accept duplicate values (Journal Title) because no two journals will have the same name.
In another, I am working with author information. I think to allow only unique records i will need to check last name, first name,...
|
by: N2Deep |
last post by:
I have a table named SUPPORT DATA, I have a field named Serial Number. In the Serial Number field I have many duplicates, and I only want one of each.
Sample serials ABB045000MG, JBX05050016
Until now I have been running an update query which identifies the duplicate serial numbers in the SUPPORT DATA table by:
In (SELECT FROM As Tmp GROUP BY HAVING Count(*)>1 ) And Is Not Null
When it finds duplicates it updates a field called...
|
by: nhatto |
last post by:
Hello
I have Two Tables ( Table A and Table B)
Table A has one field : email
Table B has three Fields : First name, Last name , email
I want to check if the email in Table B is found in Table A, And if it is , then I want to delete the row ( First name, Last name , email ) from Table B that has that email.
any help is really appreciated and thank you in advance!
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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: 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?
| |
