Updating using 2 tables with sql

SELECT * FROM SALESSUMMARY; -------------- ------------- ---------------- ------------------ | product_name | total_sales | avg_unit_price | total_units_sold | -------------- ------------- ---------------- ------------------ | cucumber | 100.25 | 90.00 | 2 | -------------- ------------- ---------------- ------------------ 1 row in set (0.00 sec) When you issue a SHOW TABLES command, then your temporary table will not be listed out in the list.

You probably arrived at this page because you are a business professional who has to present regularly to management or executives on analysis you have done in Excel.

So you want to link the table or graph in Excel to your Power Point slide.

Then when the numbers change next week or month, the Power Point slide can automatically update. Except every great idea does have potential downsides you need to know about.

When I run this query, it is returning Incorrect syntax near COLLATE.

'cust_city' and 'working_area' of 'customer' and 'agents' table must be same,5.

'cust_code' of 'orders' and 'customer' table must be same, 6.

This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Hi, I have two databases Db1 is in collation "SQL_Latin1_General_CP1_CI_AS" and Db2 is in collation "Compatibility_52_409_30003".

Now I need to get records based on the values that i have in these two databases.