Any SQL gurus in the house? :D

You could try your question and see...
 

My Computer

System One

  • OS
    Windows 10 Pro Prieview x64
    Computer type
    Laptop
    System Manufacturer/Model
    MacBook Pro Core2Duo
    CPU
    T7600
    Memory
    3
    Graphics Card(s)
    ATI Radeon X1600
    Monitor(s) Displays
    Internal
    Screen Resolution
    1440 x 800
    Hard Drives
    40GB
    Keyboard
    Apple
    Mouse
    Apple
    Internet Speed
    Varies
    Browser
    Various
    Antivirus
    Defender
Yes, there are SQL gurus in the house. Please post your question.
 

My Computer

System One

  • OS
    Microsoft Windows 8.1 64 Bit
    Computer type
    Laptop
    System Manufacturer/Model
    Toshiba C55Dt-A5106
    CPU
    Processor AMD A6-5200 APU with Radeon(TM) HD Graphics, 2 Ghz, 4 Core(s), 4 Logical Processor(s)
    Motherboard
    Toshiba PSCFWU-02C031
    Memory
    4GB
    Graphics Card(s)
    AMD Radeon HD 8400
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    Laptop and DELL E193FP
    Screen Resolution
    1366x768 1280x1024
    Hard Drives
    Toshiba MQ01ABD075
    DVD Writer TSSTcorp CDDVDW SU-208FB
    Keyboard
    Logitech Wave 2.4 Cordless or Laptop Standard PS/2 Keyboard Enhanced
    Mouse
    Logitech M1100 Performance Laser Cordless Combo or Logitech G500
    Internet Speed
    Upload/Download 91/11Mbps
    Browser
    IE 11
    Antivirus
    Norton
    Other Info
    Toshiba System Settings V1.1.2.32001
    BIOS Version Inside Corp., 1.60, 11/15/2013
    EC (Embedded Controller) Version 1.20
    Hardware Abstraction Layer 6.3.9600.16500
adamf said:
You could try your question and see...
Click to expand...

JHough said:
Yes, there are SQL gurus in the house. Please post your question.
Click to expand...

I have almost a million and one questions T.T (that's an exaggeration if there's any doubt). But, I'll start with the first :p

So I have two tables, and I need to do an inner join (I'm guessing :c) so I get all the records with Destination ID and Origin ID which match those of Airport ID (which I need to run a query to get).

Um, frankly I have no idea what I'm saying ._.
Here's a picture, hopefully this'll make more sense. Attributes in the table are different to the code, please use the one's in the table >.<

6STAt0T.png


E: So after a lot of ashdkahskjasdas-ing. I came up with this bs. Can someone tell how to optimise this ._. I wrote it in the worst way possible.


[SQL] SELECT ORIGINAIRPORT.`flightnum`, ORIGINAIRPORT.`origin airport`, - Pastebin.com :(
 
Last edited:

My Computer

System One

  • OS
    Win 8.1 Pro
You must log in or register to reply here.
Back
Top