473,325 Members | 2,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

[basic]union-join questions

144 100+
hi,
this is some concept question

i've used join with select command. can i use join on delete / update or any other command? can i have some example given?

what about union, can i union select with delete or delete with delete, i mean any other combination beside select ... union select ...


thank you very much
Mar 5 '08 #1
4 1372
amitpatel66
2,367 Expert 2GB
hi,
this is some concept question

i've used join with select command. can i use join on delete / update or any other command? can i have some example given?

what about union, can i union select with delete or delete with delete, i mean any other combination beside select ... union select ...


thank you very much

Yes you can use JOINS in DELETE,UPDATE and INSERT....SELECT statements

No, you cannot use UNION with DELETE, UPDATE statements.
Mar 5 '08 #2
thesti
144 100+
hi amitpatel66,
thank you for the quick reply.

in fact that i'm learning sql. i'm sry for my stupid question.

what about natural join, straight join, equi join?

i use Ms SQL 2k help and MySQL manual as my references. and i see some differences in both. is that because different vendor has add some feature to its SQL so its SQL is differnt from standard sql?

thx in advance
Mar 5 '08 #3
amitpatel66
2,367 Expert 2GB
Hi Thesti,

Your questions are very much theoritical and is out of scope of this forum. Please refer some online tutorial or some MSSQL books for answers. Thanks.
Mar 5 '08 #4
ck9663
2,878 Expert 2GB
Here's more.

Happy coding.

-- CK
Mar 5 '08 #5

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

Similar topics

2
by: G Hopper | last post by:
Ok, I'm a beginner so forgive me for my ignorance. Could someone help me with this? tbl_x has two fields xid and xlist xlist being a list of numbers.....1, 5, 6, 8 i want to create a new...
2
by: d2r2 | last post by:
Hi, I'm trying to run a nested (UNION) query against a MSAccessXP database (version 2002; build 10.6501.6714; SP3) In Access the SQL-statement executes just fine. When I run it in a asp-page I...
2
by: Jeff Massung | last post by:
I am having a syntax issue that I hope someone else here knows how to rectify... I am loading an INI file and have a simple function to load values from it. The function is overloaded with the...
14
by: deko | last post by:
For some reason this does not seem to be working... Am I missing something basic? Dim rst As DAO.Recordset Dim db As DAO.Database Set db = CurrentDb Set rst = db.OpenRecordset("qryEmailS") '...
6
by: Neil Zanella | last post by:
Hello, I would like to know what the C standards (and in particular the C99 standard) have to say about union initializers with regards to the following code snippet (which compiles fine under...
10
by: Jason Curl | last post by:
Greetings, I have an array of 32 values. This makes it extremely fast to access elements in this array based on an index provided by a separate enum. This array is defined of type "unsigned long...
1
by: SAKTHIVEL | last post by:
Hi, Im developing applications using Visual Basic and MS-Access 2003. Union query solves my specific problems. But I unable to call this query from visual basic form like other queries. The query...
11
by: Israel | last post by:
I've trying to write a query that seems like it should be simple but for some reason my attempts are not working. This is really a general SQL quesion and doesn't pertain to MySQL but I couldn't...
6
by: Bob Altman | last post by:
Hi all, I'm struggling to do something really basic. How do I declare a structure that has a union that maps an array of 3 chars with 3 distinct char variables. In other words, I want the...
2
ck9663
by: ck9663 | last post by:
my turn to ask the question...i have a trigger it's very basic... INSTEAD OF UPDATE ... ... ... insert into mytable (field1, field2) select field1, field2 from inserted where...
0
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
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...
1
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)...
1
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....
0
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
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.