I am new to writing more involved sql queries and need a bit of help.
I need to write to capture the following:
data from 2 columns in one table in Database 1, then I need to capture 3 columns from one table in Database 2
I think I have an example (keep in mind just an example.) which is working , however I need to AVG one column and MAX another.
I having an issue tying all this together.
Any help would be great, the real assistance would be how to aggregate the data I need and add it to my query.
Any help is appreciated.