I want to select only 'familylist' using name 'Pankaj Lagad'. But it is giving output (Vijay Yadav, Amit Patil, null, null) I don't want "null" entry in output How to solve this problem. I am new in SQL DB.
**********DB Design*********** CREATE TABLE android_metadata (locale TEXT);
CREATE TABLE RegistrationTable (_id integer PRIMARY KEY autoincrement,name UNIQUE,displayname,password,email,path);
CREATE TABLE FriendCircleListsTable (name CONSTRAINT [name] REFERENCES RegistrationTable,contactnumber,familylist,coworkerlist,schoolfriendlist);
Aucun commentaire:
Enregistrer un commentaire