[Résolu] Conditions complexe

[Single Dark]

J'ai résolu le problème grace a la conditions NOT IN.

La requete donne sa :

Code PHP :

<?php 

$requete_test_bat    =    mysql_query    ('SELECT * FROM sc_table_info_bat WHERE sc_table_info_bat.id NOT IN (SELECT id_batiments FROM sc_table_planete_bat WHERE id_planete="' . $_SESSION['id_planete'] . '")') or die('ERREUR SQL <br />'.mysql_error());