I have a table on an offline database having let say 2000 rows and same table on an online database with let say 3000 rows. Now I want to copy just those records (1000) from online database that are not in the offline database table. Also, both tables have same name, same schema etc.

Above query works well but I am facing some other problems.

I have ProductName, ProductPrice, ProductSize columns as well in OrderDetail table and Discount in Order table. I also want these columns too but when I select these columns, it gives an error of GROUP BY clause of each newely selected column.

Is there any solution. Following is the sample solution that I want

OrderID---------Total-----------...

Above query works well but I am facing some other problems.

I have ProductName, ProductPrice, ProductSize columns as well in OrderDetail table. I also want these columns too but when I select these columns, it gives an error of GROUP BY clause of each newely selected column.

Is there any solution. Following is the sample solution that I want

OrderID----------Total----------ProductName----------ProductPrice----------ProductSize...