Hey all,
I need to join 2 tables like the following scenario below, can anyone enlighten me as to what type of join this would be (or better yet an example of how the query would be set up)?
.....
Example -
Student Table A has 5 columns (firstname, lastname, gender, section_A_id, section_B_id)
Student Table B has 2 columns (id, sectionname)
I want this returned in 1...
2 results in 0.0015 seconds.
-
What type of join is this?
-
TSQL query
I had to write a valid TSQL query that does all the following in a transaction and will rollback if any system error is thrown.
• Create the following tables Customer, Order and Address where Customer can have many Orders and many Addresses. Order can only have one Address. Customer will have a column called CustomerNum of type NVARCHAR(3).
• Develop a SQL function that provides a unique, incremented CustomerNum in the form...
