Re: Help!!! on SqlPlus query

Try this for the first one:
SELECT h.name_h, m.name_m

    FROM hospital h, medecin m, hos_med lm  WHERE hm.code_m = m.code_name

        AND hm.code_h h.code_h;

Let me know how it goes. If it works, I'll try the second one for you :-) Received on Fri Apr 09 1999 - 09:10:10 CDT