|
<blockquote id="quote"><font size="3" face="book antiqua" id="quote">quote:<hr height="1" noshade id="quote">
<i>SELECT
FtW_Game_Map_Side.Map_Side_ID,
FtW_Game_Map_Side.Map_Side_Desc,
q_FtW_Map_City_Connect_Union.Map_City_To AS Map_City_ID,
FtW_Game_Map_State.Map_State_Name,
FtW_Game_Map_City.Map_City_Name,
q_FtW_Map_City_Connect_Union.Map_City_From AS Adj_City_ID,
FtW_Game_Map_City_1.Map_City_Name AS Adj_City_Name,
FtW_Game_Map_State_1.Map_State_Name AS Adj_State_Name,
FtW_Game_Map_Side_1.Map_Side_ID AS Adj_City_Side_ID,
FtW_Game_Map_Side_1.Map_Side_Desc AS Adj_City_Side_Desc,
FtW_Game_Map_Connect_Type.Map_Connect_Type_ID AS Adj_City_Connect_ID,
FtW_Game_Map_Connect_Type.Map_Connect_Type_Desc AS Adj_City_Connect_Type,
FtW_Game_Map_City_Occupied.Game_Team_ID AS Adj_Team_ID,
FtW_Game_Team.Game_Team_Desc AS Adj_Team_Desc,
FtW_Game_Team_Army.Game_Army_ID AS Adj_Army_ID,
FtW_Game_Army.Game_Army_Desc AS Adj_Army_Desc,
FtW_Game_Army.Game_Side_ID AS Adj_Army_Side_ID,
FtW_Game_Side.Game_Side_Desc AS Adj_Army_Side_Desc
FROM
((((((FtW_Game_Map_City AS FtW_Game_Map_City_1 INNER JOIN FtW_Game_Map_State AS FtW_Game_Map_State_1 ON FtW_Game_Map_City_1.Map_State_ID = FtW_Game_Map_State_1.Map_State_ID) INNER JOIN FtW_Game_Map_Region AS FtW_Game_Map_Region_1 ON FtW_Game_Map_State_1.Map_Region_ID = FtW_Game_Map_Region_1.Map_Region_ID) INNER JOIN FtW_Game_Map_Side AS FtW_Game_Map_Side_1 ON FtW_Game_Map_Region_1.Map_Side_ID = FtW_Game_Map_Side_1.Map_Side_ID) INNER JOIN q_FtW_Map_City_Connect_Union ON FtW_Game_Map_City_1.Map_City_ID = q_FtW_Map_City_Connect_Union.Map_City_From) INNER JOIN ((((FtW_Game_Map_City_Occupied LEFT JOIN FtW_Game_Team ON FtW_Game_Map_City_Occupied.Game_Team_ID = FtW_Game_Team.Game_Team_ID) LEFT JOIN FtW_Game_Team_Army ON FtW_Game_Team.Game_Team_ID = FtW_Game_Team_Army.Game_Team_ID) LEFT JOIN FtW_Game_Army ON FtW_Game_Team_Army.Game_Army_ID = FtW_Game_Army.Game_Army_ID) LEFT JOIN FtW_Game_Side ON FtW_Game_Army.Game_Side_ID = FtW_Game_Side.Game_Side_ID) ON FtW_Game_Map_City_1.Map_City_ID = FtW_Game_Map_City_Occupied.Map_City_ID) INNER JOIN (((FtW_Game_Map_City INNER JOIN FtW_Game_Map_State ON FtW_Game_Map_City.Map_State_ID = FtW_Game_Map_State.Map_State_ID) INNER JOIN FtW_Game_Map_Region ON FtW_Game_Map_State.Map_Region_ID = FtW_Game_Map_Region.Map_Region_ID) INNER JOIN FtW_Game_Map_Side ON FtW_Game_Map_Region.Map_Side_ID = FtW_Game_Map_Side.Map_Side_ID) ON q_FtW_Map_City_Connect_Union.Map_City_To = FtW_Game_Map_City.Map_City_ID) INNER JOIN FtW_Game_Map_Connect_Type ON q_FtW_Map_City_Connect_Union.Map_Connect_Type_ID = FtW_Game_Map_Connect_Type.Map_Connect_Type_ID
WHERE
FtW_Game_Map_Connect_Type.Map_Connect_Type_ID < 5
AND
q_FtW_Map_City_Connect_Union.Map_City_To = #Get_Recruit_Cities.Map_City_ID#
ORDER BY
FtW_Game_Map_Side.Map_Side_Desc,
FtW_Game_Map_State.Map_State_Name,
FtW_Game_Map_City.Map_City_Name
</i>
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">
Dang, I thought I was guilty of overly complex sql statments. You sure you've got your database properly normalized? What database are you using, BTW?
|