Viewing 7 posts - 1 through 7 (of 7 total)
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...
April 16, 2013 at 6:34 am
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...
April 15, 2013 at 10:15 am
Should I use filter criteria with the NULL for this field if so how.
October 26, 2012 at 12:53 pm
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...
October 26, 2012 at 10:38 am
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...
October 26, 2012 at 7:11 am
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)
October 26, 2012 at 6:42 am
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"...
October 26, 2012 at 5:43 am
Viewing 7 posts - 1 through 7 (of 7 total)