[basic]union-join questions

[thesti]

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

[amitpatel66]

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....SELEC T statements

No, you cannot use UNION with DELETE, UPDATE statements.

[thesti]

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

[amitpatel66]

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.

[ck9663]

Here's more.

Happy coding.

-- CK