Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Find client accounts missing a specific service

    Hey Lowell this the actual code I ran(below), the only changes were to the table and column names. What was returned was the PORTFOLIO column and 0 rows. As I...

  • RE: Find client accounts missing a specific service

    Thanks Lowell for the quick reply. But when I altered the code as you presented it the query returned nothing. I would be satisfied if that were the case but...

  • RE: != NOT EQUAL TO Query

    Should I use filter criteria with the NULL for this field if so how.

  • RE: != NOT EQUAL TO Query

    Thanks Lowell, I tried the LEFT OUTER JOIN for both instances. First with the same code I posted, no records returned with successful query. Then with all tables referenced using...

  • RE: != NOT EQUAL TO Query

    When I INNER JOIN all my tables (6) I pull all the records for a specific region which already have the field data I am querying to see is...

  • RE: != NOT EQUAL TO Query

    As fars properties go this is as much as I have access to:

    TABLE_QUALIFIER

    Db.dproperties

    Db.dproperties

    Db.dproperties

    Db.dproperties

    Db.dproperties

    Db.dproperties

    Db.dproperties

    Db.dproperties

    TABLE_OWNER

    Db

    Db

    Db

    Db

    Db

    Db

    Db

    Db

    TABLE_NAMES

    Db.dbase

    Db.dbase

    Db.dbase

    Db.dbase

    Db.dbase

    Db.dbase

    Db.Services

    Db.Services

    COLUMN_NAMES

    name

    ID_num

    ID_Type

    GroupName

    Region

    ROW_ID

    Type

    ROW_ID

    (varchar(100), null)

    (varchar(100), null)

    (varchar(100), null)

    (varchar(100), null)

    (varchar(25), null)

    (varchar(15), null)

    (varchar(100), null)

    (varchar(15), null)

  • RE: != NOT EQUAL TO Query

    Thanks all the parenthesis don't seem to have anything to do with it I'm thinking it's the "!=", Query runs successful but does not return any records.

    Tried "IS NOT"...

Viewing 7 posts - 1 through 7 (of 7 total)