[thelist] sql join statement
Mike D. Johnson
mdjohnson at bcbe.org
Tue Jul 12 08:43:10 CDT 2005
I am trying to select data from three different tables and can't get it
to work. I have three tables with these fields:
user table
userName
userLname
userFname
shift table
shiftID
shiftDate
shiftStartTime
shiftEndTime
saleID
shiftUserLinkTable
shiftID
userName
I need to select the shifts users are working at this sale and display
it like this:
UserFname userLname
shiftDate shiftStartTime shiftEndTime
Bob Smith
7/15/2005 8:00 AM - 9:00 AM
7/15/2005 10:00 AM - 11:00 AM
Larry Jones
7/15/2005 10:00 AM - 11:00 AM
7/15/2005 12:00 PM - 1:00 PM
I'm using MS Access and ASP (vbScript) for this.
I need help constructing the sql statement to select this information.
I'd also appreciate any links to sites with more info on doing this so I
can figure it out on my own next time.
Thanks,
Mike
More information about the thelist
mailing list