mysql - Incredibly hard join (for me) -

I've been trying to create a web interface for a C ++ game for a friend. Unfortunately I'm not a php / sql master.

This is particularly difficult when I need to join tables. I am not good with those people.

To show you what it looks like: (I have to get all the members of a guild)

  Guild & gt; The Bads ------------------------------- Rank Player Name ------------- - ----------------- Big boss. Midwayle Hernfreck Loss | Crane The Hunter Saint Seaner Cole The Conquer Jaazzy The Beat Nowis. IGOS DUKANA --------------------------------  

The table looks like this : '' Circles '' (`id 'int (10) unsigned, not tap AUT agreement,` name' varchar (255) No tap, 'founder' int (11) tap, primary key (

`Id``) create table 'guild_ranks` (` id` int (10) unsigned, not tap autencraman, `guild_id` et (10) unsigned null;` name' varchar (255) no, zero, `access' '' Id '' (10) unsigned null AUT agreement, `name 'varchar (255) Yes, zero, `account_id` at (10) unsigned, tap the rank_id` int (10) unsigned)

Say you get all the guild members of Guild ID 114 How would you do this?

Many thanks!

 < Select> guild_ranks.name, players.names from players guild_ranks.id from guild_ranks = Players.rank_id - At least this is how I believe they have joined ... WHERE guild_ranks.guil D_id = Order 114 By guild_ranks.name;