Re: [orientdb] SQL Select fields that have no data (null) in result set

Yes, photo is declared in the schema. On Wednesday, September 9, 2015 at 2:33:46 AM UTC-4, Enrico Risa wrote: > > Hi Scott > > is the field photo declared in the schema? > > 2015-09-08 17:32 GMT+02:00 Scott Wruble > > : > >> If I have a vertex, users, that has the following properties: firstname

Re: [orientdb] SQL Select fields that have no data (null) in result set

Hi Scott is the field photo declared in the schema? 2015-09-08 17:32 GMT+02:00 Scott Wruble : > If I have a vertex, users, that has the following properties: firstname, > lastname, photo. Photo can be null. If I have the following records: > > Jane | Doe | > John | Doe | > John | Smith

[orientdb] SQL Select fields that have no data (null) in result set

If I have a vertex, users, that has the following properties: firstname, lastname, photo. Photo can be null. If I have the following records: Jane | Doe | John | Doe | John | Smith | pic1.jpg Using this SQL in JDBC: select firstname, lastname, photo from users I get the expected resul