null results from query

[fife]

I have a tripple join that is working as it should.  How ever I want it to bring back all results even it there are no results in the news table.  There will always be a network but not news for a network.

 

  Here is the query

SELECT news.*, members.*, networks.* FROM news 
INNER JOIN members ON members.idmembers = news.idmember 
INNER JOIN networks ON networks.idnetworks = news.idnetwork 
WHERE news.idnetwork='".$_GET['network']."' ORDER BY news.idnews DESC

 

Ive tried left join and right join on the second inner join but still it does not bring back any results.  if there is a news item it works great but it needs to without a news item

 

[Barand]

try

 

$sql = "SELECT *
FROM networks 
    LEFT JOIN news ON networks.idnetworks = news.idnetwork 
    LEFT JOIN members ON members.idmembers = news.idmember
WHERE networks.idnetworks = {$_GET['network']}
ORDER BY news.idnews DESC";

[fife]

ok ive tried left left, right right, right left and left right but none of them display if there is no article in the news table

[fife]

Brand thank you

[fife]

barand even