Welcome Guest, Not a member yet? Register   Sign In
My join is not working
#5

I have three tables the phones table which has these fields(users, numbers, offices and id). The offices field is a foreign key which references the id field in the offices table. The offices table has these fields(names, id and departments). The departments field in the office table is a foreign key which references the id field in the departments table. The departments table has these fields(names, id). I want the query to return the results if the user enters a department or an office or a phone number
Reply


Messages In This Thread
My join is not working - by andyblem - 02-19-2015, 06:00 AM
RE: My join is not working - by Avenirer - 02-19-2015, 06:46 AM
RE: My join is not working - by marcos - 02-19-2015, 07:49 AM
RE: My join is not working - by edellascenza - 02-19-2015, 10:54 AM
RE: My join is not working - by andyblem - 02-19-2015, 11:43 PM
RE: My join is not working - by Rufnex - 02-20-2015, 02:47 AM



Theme © iAndrew 2016 - Forum software by © MyBB