Problema estrazione dati

[TheShark07]

vorrei che tahulis_userlists.hub_users venisse visualizzato insieme a ahulis_hublist.hub_name,tahulis_hublist.hub_addres s,tahulis_hublist.hub_soft,tahulis_hublist.hub_nat ion,tahulis_hublist.id
solo che nn riesco a mettere in una query unika tutto quanto se lascio cosi il campo tahulis_userlists.hub_users non viene visualizzato

     if ($filterSql == '') $filterSql = " WHERE 1 ";
     $selectAllSql  = "SELECT tahulis_userlists.hub_users FROM tahulis_userlists".$filterSql;

	 $ResultAll     = $MyDb_xhublist->f_ExecuteSql($selectAllSql);
     $ResultAllRows = $MyDb_xhublist->f_GetSelectedRows($ResultAll);

     $selectAllSql  = "SELECT tahulis_hublist.hub_name,tahulis_hublist.hub_address,tahulis_hublist.hub_soft,tahulis_hublist.hub_nation,tahulis_hublist.id FROM tahulis_hublist".$filterSql;

[TheShark07]

ho provato a metterla cosi ma non va

     $selectAllSql  = "SELECT tahulis_hublist.hub_name,tahulis_hublist.hub_address,tahulis_hublist.hub_users,tahulis_hublist.hub_soft,tahulis_hublist.hub_nation,tahulis_hublist.id FROM tahulis_hublist INNER JOIN tahulis_userlists ON tahulis_hublist.id = tahulis_userlists.id WHERE tahulis_hublist.hub_users = tahulis_userlists.hub_users".$filterSql;
	 
	 $ResultAll     = $MyDb_xhublist->f_ExecuteSql($selectAllSql);
     $ResultAllRows = $MyDb_xhublist->f_GetSelectedRows($ResultAll);

[TheShark07]

risolto cosi ^^

     $selectAllSql  = "SELECT tahulis_hublist.hub_name,tahulis_hublist.hub_address,tahulis_userlists.hub_users,tahulis_hublist.hub_soft,tahulis_hublist.hub_nation,tahulis_hublist.id FROM tahulis_hublist INNER JOIN tahulis_userlists ON tahulis_hublist.id = tahulis_userlists.id".$filterSql;
	 
	 $ResultAll     = $MyDb_xhublist->f_ExecuteSql($selectAllSql);
     $ResultAllRows = $MyDb_xhublist->f_GetSelectedRows($ResultAll);