SQL Query

Hot Topic

i\r \n are not taken into consideration in my regex
NotSerializable type used within remote method causes serialization exception
Database Navigation : to get into the NEXT record ? code inside
How to assign Config file - created AppDomain
What is the best way to handle null values?
Why SmtpClient failed in VS 2005?
output param sql2000 / vb.net 2003
Linking to libraries not in GAC or application directory
System.IO.Ports.SerialPort Problem
Wrong link to Visual Studio 2005 extensions for .NET Framework 3.0

.NET Development

The remote name could not be resolved 'http'
Help with XML
Update Excel Data
notifyIcon works with windows forms but not services....
Display Compiled HTML help file in VB.Net app
System.Data.OleDb.DBBindings.Get_DBTIMESTAMP error on datefield
deserilaizing xml fragment in to object
Problem when starting two listening sockets simultaneously
Regional Settings, depending of the format, my .NET app cannot reach a field inside an Access2000 table...
Unknown Publisher

SQL Query

Can someone help me with an SQL query i'm trying to create. I have a 2 tables with the following attributes:

Rental: Rental_ID (represents an ID # for the rental)ID( represents a members id #), Movie_ID (represents a movies_id #), Returned, Date_Returned

and

Movie: Movie_ID, Title, Actor etc

What i want is a query that when i give the ID # for the member, it returns the details of the movie they have on rental (and not ones that have been returned)

SELECT Movie_ID, Title FROM Movie WHERE

Thanks for any help in advance

Answer this question

SQL Query

  • jwraith

    Rental: Rental_ID (represents an ID # for the rental)ID( represents a members id #), Movie_ID (represents a movies_id #), Returned, Date_Returned

    and

    Movie: Movie_ID, Title, Actor

    select Rental.*, Movie.* from Rental inner join Movie on Rental.Movie_ID=Movie.Movie_ID where Rental.ID=



  • SQL Query
Answer this question