over 7 years ago
We cannot use temporary table twice in same query.
However if you have not required above condition then Temporary table is best to use rather than creating real one
Advantages of Temporary Table:
You can create multiple temporary tables with same name in different sessions.
There is no need to drop temporary table as they get automatic clean when your session got ended
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2021 FindNerd.com. All rights reserved.
Sign up using