Awesome, crystal.clear and concise. I really found useful the second example, where you go strait and perform filtering operation. In many cases an inner ou nested query would have been used to solve that one but I persornally find it hard to read subqueries under the where clause. Thank you for the insightful tutorial.

Hey MrBrown, thank you very much for posting this vid. Your explanation helped a lot.

I spent hours with lots of videos and posts and not a single saint could finally save me. Thank you very much Mr. Brown and just in time to sent my work for evaluation here from Brazil. Best regards, Diego

How do you bulk upsert a temp table into a target table when the temp table doesn't have a PK or common field with the target table?

Much more helpful than my teacher at University, thank you so much

@michaelmimichaelmi

Жыл бұрын

Literally why I'm here myself. Wish he taught my class.

Thank you for your explanation. I hope you also use this in real life scenario. again thank you

Excellent video, thanks

Thank you very much, it is very easy and clear

Really great Tutorial :)

thank you for your explanation

Thank you so so so so much.

Cheers for the vid my fellow chimpin code puppy

How do you select an aditional third table

@mawhadmd7086

Жыл бұрын

same thing, just add the table like, FROM table 1, table 2, table 3

How can also I insert join statement in this query? Is it possible?

Thank you so much

How can sql server using this on outer join situation

I have a doubt. I have table with two fields, one field is array in table 1 uID | Contact 2 | 1221,1223 3 | 1123 Now value of 1221 and 1223 are in table Two. I want a query to join table 1 and table 2 using array of field2

May God help you, it was a very useful video

Thanks!!

Is this equivalent to JOINs ?

@ComputerScienceTutor

Жыл бұрын

Yes that can be used as an alternative