Jump to content

Search the Community

Showing results for tags 'mysql view'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • W3Schools
    • General
    • Suggestions
    • Critiques
  • HTML Forums
    • HTML/XHTML
    • CSS
  • Browser Scripting
    • JavaScript
    • VBScript
  • Server Scripting
    • Web Servers
    • Version Control
    • SQL
    • ASP
    • PHP
    • .NET
    • ColdFusion
    • Java/JSP/J2EE
    • CGI
  • XML Forums
    • XML
    • XSLT/XSL-FO
    • Schema
    • Web Services
  • Multimedia
    • Multimedia
    • FLASH

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Languages

Found 1 result

  1. Hi all, I have a table of a schedule of workers at kiosks and I have a table of drivers who drop them off and possibly a different driver picks them up. I have a view that lists other details from other tables (like times, dates, names) and I'd like to list the drop off and pickup drivers separately, because they might be different. I've tried a couple of things and got error messages - like 'referencing same table' when I tried this: create view allScheduleInfo AS ..... schedule.dropOffID, drivers.dropOffName, schedule.pickUpID, drivers.pickUpName, .... FROM schedule left join ..... left join drivers ON schedule.dropOffID = drivers.driverID left join drivers ON schedule.pickUpID = drivers.driverID .... I got it to display the view with an error message when I tried combining the joins on one line, like this --> left join drivers on schedule.dropOffID = driversID AND schedule.pickUpID = driversID And the dropOffID and pickUpID go thru correctly, but it makes the dropOffName and the pickUpName = to NULL. I considered making two separate tables for drop off and pick up drivers, but wouldn't that contradict the normalizing of table data? I know this may be kind of odd, and i hope I've explained it sufficiently that some one can point me in the right direction of how to do this. Basically I guess I am trying to access 2 pieces of information from the same table, but with different pointers to them. Thank you for your help.
×
×
  • Create New...