behnam_tr Active Member Licensed User Longtime User Dec 10, 2020 #1 hi guys i have three table i want to get date from three table with one query i confuse and i cant use JOIN keyword and i need help
hi guys i have three table i want to get date from three table with one query i confuse and i cant use JOIN keyword and i need help
Erel B4X founder Staff member Licensed User Longtime User Dec 11, 2020 #2 B4X: Expand Collapse Copy $"SELECT Students.id, name, gr, phone, city, streetname FROM students, grades, stinfo WHERE Students.id = Grades.id And Students.id = Stinfo.id And Students.id = ?"$ Upvote 0
B4X: Expand Collapse Copy $"SELECT Students.id, name, gr, phone, city, streetname FROM students, grades, stinfo WHERE Students.id = Grades.id And Students.id = Stinfo.id And Students.id = ?"$
Unobtainius Active Member Licensed User Longtime User Dec 13, 2020 #3 Unless you store multiple address for each student, why are the student and STinfo in separated tables in the first place? Upvote 0
Unless you store multiple address for each student, why are the student and STinfo in separated tables in the first place?
behnam_tr Active Member Licensed User Longtime User Dec 14, 2020 #4 Unobtainius said: Unless you store multiple address for each student, why are the student and STinfo in separated tables in the first place? Click to expand... yes your are right tables were for test and learn Upvote 0
Unobtainius said: Unless you store multiple address for each student, why are the student and STinfo in separated tables in the first place? Click to expand... yes your are right tables were for test and learn
