SELECT

Ahoj,

mam 2 tabulky
project_con [id_project, id_partner]
partner [id, ..... ]

$res = $db->Execute("SELECT * FROM project_con LEFT JOIN partner ON id_partner=id WHERE id_project=".$id_project." ORDER BY name");

timto vypisu vsechny partnery kteři jsou v projektu, ale jak jednoduse vypsat ty kteři tam nejsou?
existuje nejaka fce,ktera se jen prida do SELECTU a vypise opak? ty co tam nejsou?

Diky za odpovedi!!!

nejak nejde :(

SELECT * FROM partner WHERE id NOT IN (SELECT * FROM project_con WHERE id-project=".$id_project.")


Fatal error: Call to a member function on a non-object in

ja vim,ale stejne nefunguje, nemuze to byt tim ze mam MySQL 4.0.16 ?

to uz funguje, moc dik!

jeste jednu radu plz :)

tabulky : auth[id_user, id_partner]
project_per[id, id_user, id_project_con]

potrebuji vypsat vsechna user_id , ktera maji spolecny id_partner a zaroven jeste nejsou obsazena v project_con

SELECT * FROM auth LEFT JOIN project_per ON (auth.id_user=project_per.id_user AND auth.id_partner='$id_partner' AND project_per.id_project_con='$id_proj_con') WHERE project_per.id_user IS NULL

moc dik, nejak jsem se v tom zamotal

tak uz nic, uz to mam :)