Hi guys!
This is the first time that a post in this community and I am new working with Oracle SQL. I have a doubt about getting the max price and about the product, follow example:
I have 4 tables: Product, Computer(pc), Laptops and Printers
I doing a query to bring the result for the computers, laptops and printes tables using union function like:
But I need to include the column "company" for the product table to show together with the columns to the others tables. Which form can I adjust the query to work the information? I need to bring on the result the columns Company, Serial Number and max Price on query.
Thanks in advance for all!