473,387 Members | 1,545 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Best Way of joining four tables

I'm having mental difficulties trying to figure out a way of doing this:
I have a group members table which is a linking table containing all members and the groups/groups they belong to. I want to display a list of repertoire that is common to all the members of one of the groups stored in the Groups table.
These are the tables I have:
NAME COLUMNS
Groups group_name, group_id
Group_members user_id, group_id
Repertoire user_id, tune_id
Tunes tune_id tune_name
Can anyone help me?
Aug 6 '09 #1
2 1721
MrMancunian
569 Expert 512MB
Hi, can you specify two rows for each table and the output you want to generate? That makes it a lot less a stab in the dark :-)

Steven
Aug 10 '09 #2
numberwhun
3,509 Expert Mod 2GB
That is going to be an interesting query when you are done. Not that I don't want to help, but can we see what you have tried thus far? Can you show us your query you have been working on and tell us what it gave you and why it was wrong?

An example of the output you expect is also helpful.

Regards,

Jeff
Aug 10 '09 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Ciar?n | last post by:
I have about 7 tables I need to join, but am having a lot of difficulty with the joins, that I need some help on. I'll provide the details of four tables to illustrate the scenario. I have one...
0
by: Raheel Hussain | last post by:
hi, I have a following situations, in which I want to know about how ADO.NET is supporting. SITUATION 1 ----------- I m saving a customer record on click of Save button.
3
by: james | last post by:
Hi, I would like to get all the records from 9 tables that have the same field value in one field (it is a unique field)that is shared by all the tables. Would this method of joining work: ...
0
by: Anonieko Ramos | last post by:
ASP.NET Forms Authentication Best Practices Dr. Dobb's Journal February 2004 Protecting user information is critical By Douglas Reilly Douglas is the author of Designing Microsoft ASP.NET...
10
by: Captain Nemo | last post by:
Hi I'm working on an ASP project where the clients want to be able to effectively perform SELECT queries joining tables from two different databases (located on the same SQL-Server). Does...
3
by: Reader | last post by:
Hello all, I am joining two tables in a query and the output should be all those records where two fields in table1 match two corresponding fields in table2. I joined the tables using both...
2
by: me | last post by:
I have written a query that joins four or five tables. One table has 30,000 rows. Another table has only 200. I want to only return the 200 or so rows in the smaller table and columns from the...
2
by: Supermansteel | last post by:
I am joining these 2 tables together in Access 2003 and can't figure out the exact way of writing this script......Can anyone help? I have the following SQL: SELECT...
3
by: mansi sharma | last post by:
--Que-5) Select CTM_NBR,LIST_CODE,ADR_CDE,ADR_FLAG --From table A,B,C,D by linking the tables where --the LIST_CODE=18. TABLE A Has Column CTM_NBR ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.