The following is my statement that I put in SQL View :
SELECT DISTINCT
NO, Name, IndexNumber, Type1, Type2, StockCode,
StockShortName, ISIN
FROM Entity
WHERE (Name IN
(SELECT Name
FROM Entity AS Tmp
GROUP BY Name
HAVING COUNT(*) > 1))
ORDER BY Name
I...
Can I know how to copy a blank table (with fields) from one database (with data in the table) to another database without copying the data?
I am currently running SQL 7 (desktop version)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.