Mark -

Is this with SQL Server 2000 that you're having issues?

Can you post the exact query in question, pointing out what your particular issue is that's making it not work.. as in: are the results wrong or did an error get returned?

Thanks,
Aaron


----- Original Message ----- From: "Mark Fuqua" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, February 18, 2005 11:25 AM
Subject: [plum] Field Names



This may be silly but...I have had trouble in the past with queries where
the name of two fields in two different tables were the same.  It did not
seem to matter whether or not I used table.fieldName or just fieldName. So
I started putting the initials of the table name as a prefix to the field
name.  tableOne.toFieldName   tableTwo.ttFieldName.

Did I imagine this problem?  I want to redo a database with the naming
convetions spelled out in the plum tutorials...have you ever had any
problems with identically named fields in different tables?

Thanks,

Mark Fuqua



**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:

http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************


**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:

http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************

Reply via email to