Code For NonGeek
Would you like to react to this message? Create an account in a few clicks or log in to continue.

two tables, one with student# and name, the other with student# and parki ng#, how to find all the students that don't have parking?

Go down

two tables, one with student# and name, the other with student# and parki ng#, how to find all the students that don't have parking? Empty two tables, one with student# and name, the other with student# and parki ng#, how to find all the students that don't have parking?

Post  Admin Tue Aug 30, 2011 11:46 am

select name
from student
where name NOT IN(
select name
from student JOIN park USING(student#)
)

Admin
Admin

Posts : 131
Join date : 2011-08-16

https://codefornongeek.forumotion.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum