From: "Geo." 

nope. table accounttypes does (sortorder field is 1's and 0's).. Hmmm I
wonder if there is some subaccount that has an accounttype which no longer
exists?



nope, 79 account types, 79 accounttype definitions. I'm stumped.

Geo.

"Rich"  wrote in message news:3eef7747{at}w3.nls.net...
   Does table SubAccountDataTypes have a column named SortOrder?

Rich

  "Geo."  wrote in message
news:3eef654b$1{at}w3.nls.net...
  Ellen (or anyone who knows sql),

  Got any ideas on the cause of this error? I'm not even sure what table to
  look at from this query...

  [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
  'SortOrder'.

  --------------------------------------------------------------------------
--
  ----
  Select dt.*, at1.AccountType, CASE (Select Count(*) From SubAccountData sa
  Where sa.DataTypeID = dt.DataTypeID) WHEN 0 THEN 'Delete' ELSE '' END as
  DelLink --, ISNULL(ObjectGroup, '') as ObjectGroup From
SubAccountDataTypes
  dt, AccountTypes at1 --, ObjectGroups og Where dt.AccountTypeID *=
  at1.AccountTypeID AND dt.ExternalSystemType IS NULL -- and
dt.ObjectGroupID
  *= og.ObjectGroupID Order By dt.SortOrder

  --------------------------------------------------------------------------
--
  ----
  S0022


  Geo.

--- BBBS/NT v4.01 Flag-4