SELECT up.Path
FROM tblTwo up, tblOne un
WHERE un.UserID = up.UserID
AND un.Username = 'Billy'
On Tue, 12 Oct 2004 12:52:15 -0400, Mark Spits <[EMAIL PROTECTED]> wrote:
> I'm really new to sql and I'm trying to modify some existing code.
> Below is the sql that displays the columns in the two tables.
>
> I want to be able to insert the username into the first table and the
> directory path into the second table and then be able to extract the
> information of all the paths beings inserted based on the username.
>
> This code seems to display the information correctly (I think).
>
> I'm stuck on the code to do the insert.
>
> Here is the table structure:
>
> tblOne
> UserID Username
>
> tblTwo
> UserID Path
>
> Here is the SELECT code:
>
> SELECT up.Path
> FROM tblTwo up
> INNER JOIN tblOne u ON up.UserID = u.UserID
> WHERE u.Username = 'Billy'
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
