Ok I got this. The view is setup and working now. Thanks for the help!

This sounds like a good idea but how do I change [Column Name] to ColumnName?

[Column Name] AS ColumnName?

Regarding this geniousconnect program, does anybody here have first hand experience with it?

It would be really helpful to me to hear some experiences.

Thank you for the advice Gift. The problem was with the catalogs. Since the old HD was copied to the new one it seems that the files for the catalog...

Thank you for the advice Gift. The problem was with the catalogs. Since the old HD was copied to the new one it seems that the files for the catalog...

Thank you for the advice Gift. The problem was with the catalogs. Since the old HD was copied to the new one it seems that the files for the catalog...

Thank you for the advice Gift. The problem was with the catalogs. Since the old HD was copied to the new one it seems that the files for the catalog...

Thank you for the advice Gift. The problem was with the catalogs. Since the old HD was copied to the new one it seems that the files for the catalog...

Thank you for the advice Gift. The problem was with the catalogs. Since the old HD was copied to the new one it seems that the files for the catalog...

Frances

I am also trying to learn to use this feature. Actually I need to fix it...

Here is some information I have found useful:

http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c03ppcsq.mspx

If you can't solve it or you do solve it please post back here. I am interested in helping out or hearing from others using this combination.

Also I found...

Hi Terry,

I have done an experiment with the self join method and the result was good. It really doesn't seem any more complicated either. e.g.

SELECT D2.uniqueID,...

Maybe this will help. I recently needed to get the last record ID from my table.

SELECT TOP 1 recordID

FROM yourTable

ORDER BY recordID DESC

Of course I am using SQL 2K but...

I have been developing with the Zope application server now for more than 5 years. As you may know this software includes an OO DB called the ZODB. So far...

Alright John,

After mucking around with my tables here is what I came up with:

SELECT LastName

FROM TempSig TS JOIN TEMPLATE T

ON TS.TemplateID = T.TemplateID

JOIN SIGNATURE S

ON TS.sigID = S.SignatureID

WHERE T.Description...