Hello everyone,
I'm programming in VB.NET 2005 and I habe not much experience with database
programming. I'm in search for some sql for the following :
I have 3 database tables: Movies, Theaters and a MovieProgram. Now I'm
looking for some TSQL (SQL SERVER 2005) that can do the following:
In a combobox a select a movie and the sql will serve to populate a
datagridview with all the theaters that are linked true the programma-table
where that movies play; on the other hand if a select an theater in a
combobox I want to fill a datagridview with all the movies that are playing
in that theater.
Thanks in advance,
Benny
