vendredi 11 mars 2016

***How to select only perticular rows using Foreign Key constraint in MySQL?

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.

screenshot

**********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