HomeworkLib
Question

I can’t figure out how to combine the results from one select statement with the results...

I can’t figure out how to combine the results from one select statement with the results from another so that the results are side by side. Using Union causes the results of the second statement to add rows below the first results.

The first select has sales_rep_id and number_of_customers.

The second select has total_number_of_parts and total_customer_sales.

I had to create ‘null as’ statements to create the proper columns in each of the statements so that the results from the second select wouldn’t go into the columns for the first.

So for the first result we have: 3, 3, null, null

The second result would have: null, null, 12, 171.94

What I want is for it to be: 3, 3, 12, 171.94

MySQL is not fun and this is driving me crazy, I have been stuck on this for 2 days. Any guidance would be appreciated.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Answer:-

Note:- You can use Cartesian product of two tables.(it will add each row of first table to each row of second table).

Select * from (first select statement) , (second select statement).

Note:- if you have any further doubt feel free to write in the comment box.

0 0
Add a comment
Know the answer?
Add Answer to:
I can’t figure out how to combine the results from one select statement with the results...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • MySQL 11. Final challenges Reset challenge database If you make a mistake while editing the database...

    MySQL 11. Final challenges Reset challenge database If you make a mistake while editing the database in this section or just want to reset the database back to its original state, return to this page and click the “Reset Section Database” button below. RESET CHALLENGE DATABASE If I have seen further, it is by standing on the shoulders of giants. (Bernard of Chartres). Databases are fun. Let’s honour some of the most popular scientists of all times by creating a...

  • #6 Write a SELECT statement that returns these columns: The count of the number of orders...

    #6 Write a SELECT statement that returns these columns: The count of the number of orders in the Orders table The sum of the tax_amount columns in the Orders table Write a SELECT statement that returns one row for each category that has products with these columns: The category_name column from the Categories table The count of the products in the Products table The list price of the most expensive product in the Products table Sort the result set so...

  • 5. Write a SELECT statement that returns these columns from the Orders table: OrderID OrderDate ShipDate...

    5. Write a SELECT statement that returns these columns from the Orders table: OrderID OrderDate ShipDate Return only the rows where the ShipDate column contains a null value. 6. Write a SELECT statement that returns all columns from the Addresses table State is equal to CA 7. Write a SELECT statement that returns all columns from the Products table Product name has a "ru" in its name 8. Write a SELECT statement that returns these columns from the Customers table...

  • //please help I can’t figure out how to print and can’t get the random numbers to...

    //please help I can’t figure out how to print and can’t get the random numbers to print. Please help, I have the prompt attached. Thanks import java.util.*; public class Test { /** Main method */ public static void main(String[] args) { double[][] matrix = getMatrix(); // Display the sum of each column for (int col = 0; col < matrix[0].length; col++) { System.out.println( "Sum " + col + " is " + sumColumn(matrix, col)); } } /** getMatrix initializes an...

  • I can’t figure out how to solve this. A person stands 6.00 m from a speaker,...

    I can’t figure out how to solve this. A person stands 6.00 m from a speaker, and 8.00 m from an identical speaker. What is the wavelength of the first (n-0) interference minimum (destructive)? (Speed of sound 343 m/s) (Unit m)

  • MYSQL Consider the sql statement "select * from t1 UNION t2" where t1 and t2 are...

    MYSQL Consider the sql statement "select * from t1 UNION t2" where t1 and t2 are two sets (tables). This query executes without any errors. Assume t1 has n columns. How many columns does t2 have? How many columns will the resultset have? Is it possible for the result set to have more records than the combination of t1 and t2 (for example say t1 has 8 records and t2 has 8 records) is it possible for the resultset to...

  • How do I combine these two SELECT query into one INSERT?Selecting a value from different tables...

    How do I combine these two SELECT query into one INSERT?Selecting a value from different tables in ORACLE? I inserted a row into vehicle_unit by using INSERT this way: INSERT INTO vehicle_unit(vunit_id,vunit_purchase_price,vunit_exhibition_flag,vehicle_insurance_id,vunit_rego, garage_code) SELECT '3',50000.00, 'R', 'sports-ute-449-12b ', 'RD3000', garage_code FROM garage WHERE garage_email ='melbournec@rdbms.example.com '; BUT now I do not want to manually enter sports-ute-449-12b. I want to select it from vehicle_detail table using the vehicle_title like this: SELECT vehicle_insurance_id FROM vehicle_detail WHERE vehicle_title= 'Toyota Hilux SR Manual 4x2...

  • the two codes have an error and I can’t figure out where. First one public class...

    the two codes have an error and I can’t figure out where. First one public class Program { public static void main(String[] args) { int i, j = 1, k = 0; String alphabet = "abcdefghijklmnopqrstuvwxyz"; i = alphabet.length(); while (i>0){ j=(i-(i-j)); System.ou.println(alphabet.charAt(k)+" is the number "+j"letter in the alphabet"); k++; j++; i--; }    } } Second one char [] alphabet = {a,b,c,d,e,f,g,h,I,j,k,l,m,n,o,p,a,r,s,t,u,v,w,x,y,z};    for (int i = 0; i < alphabet.length; i++)    {        System.out.println(alphabet[i] +...

  • WRITE A SQL QUERY SQL SERVER Write a SELECT statement that returns one column from the...

    WRITE A SQL QUERY SQL SERVER Write a SELECT statement that returns one column from the Customers table named FullName that joins the LastName and FirstName columns. --       Format this column with the last name, a comma, a space, and the first name like this: --       Doe, John --       Sort the result set by last name in ascending sequence. --       Return only the contacts whose last name begins with a letter from M to Z. --  ...

  • I need help with the following problem: Using the classicmodels database you installed from Module 1,...

    I need help with the following problem: Using the classicmodels database you installed from Module 1, provide an example query using both a group by clause and a having clause. Show no more than ten rows of your query result. Discuss if the query you wrote can be rewritten without those clauses. I have come up with the following for the first part of the question: mysql> select offices.city, count(employees.employeenumber) as NumberOfEmployees from Employees -> inner join offices on offices.officecode...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT