Hi, I have these 2 table. I need a query that will result BDStudenti.nume, Note.nota if i have BDStudenti.grupa and Note.ide

BDStudenti

nrmatricol int(5) PK
cnp bigint(20)
nume varchar(50)
grupa int(5)


Note

idn int(5) PK
nrmatricol int(5)
ide int(5)
nota int(5)


I tried this but it does not work
thanks for the help

SELECT Note.nota, BDStudenti.nume from Note, BDStudenti
WHERE BDStudenti.grupa =501 and Note.ide =1
AND Note.nrmatricol = BDStudenti.nrmatricol

I should say more...

You need to bind the nrmatrocol rows in Note that match the nrmatricol primary key in BDStudenti. If you don't you will get all the rows in both tables and a lot of result you don't want.

Ken

thanks don't know how I didn't see that

edit: that was exactly my problem with the code i had before

That's why companies put two programmers in one cubicle. Sometimes a little over-the-shoulder comment saves a lot of time. We all miss the obvious at times.

Ken