[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