Windows 8 and 8.1 Forums


Any SQL gurus in the house? :D

  1. #1


    Posts : 51
    Win 8.1 Pro

    Any SQL gurus in the house? :D


    So. Basically.

    I need some help with sql stuff

    Anyone want to help me?!

      My System SpecsSystem Spec

  2. #2


    Posts : 1,875
    Windows 10 Pro Prieview x64


    You could try your question and see...
      My System SpecsSystem Spec

  3. #3


    Pittsburgh
    Posts : 103
    Microsoft Windows 8.1 64 Bit


    Yes, there are SQL gurus in the house. Please post your question.
      My System SpecsSystem Spec

  4. #4


    Posts : 51
    Win 8.1 Pro


    Quote Originally Posted by adamf View Post
    You could try your question and see...
    Quote Originally Posted by JHough View Post
    Yes, there are SQL gurus in the house. Please post your question.
    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 >.<



    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 by Reddd; 30 Nov 2014 at 10:12.
      My System SpecsSystem Spec

Any SQL gurus in the house? :D
Related Threads
So I would like to set up a server for the house, the three things I would like to do with this is for it to run plex media server so I can stream the videos from this to my TV, backup two Windows machines to and host a game called minetest for me and my sister to play off of. I am looking at some...
I am looking for people to review a description of Windows internals for the forthcoming new edition of my Operating Systems textbook. The current edition has a 33-page description of Windows 7 internals. Your mission, should you decide to accept it, is to carefully read all or as much as you are...
Hey everyone. You guys missed some unusual excitement that occurred Saturday by our house. Not the typical thing we have to put up with on a weekend afternoon. So I go down into the basement storage room to get some toilet paper. I come back out, am about to go back upstairs, but something...
I bought my online upgrade and let it proceed from W7 and later downloaded and burned the .iso, so what I have is a true upgrade from W7 and not a clean install. I really have no big issues, just anoyances really, with my live tiles. My Live tiles don't update them selves unless I open them...
Windows 8 House Party in General Support
Just before the launch of Windows 7, Microsoft and House Party did an event that you would launch a party with people and get Windows 7 for free. Do you want a Windows 8 House Party?
Eight Forums Android App Eight Forums IOS App Follow us on Facebook