mysql> SELECT t.Name, h.HD, h.BayerFlam, h.ProperName, h.RA, h.Declination, h.Distance, h.Mag FROM tblStarTrek AS t, tblHYG AS h WHERE t.StarID = h.StarID ORDER BY t.Name; +--------------------+--------+------------+---------------+------------------+-------------------+----------+-------+ | Name | HD | BayerFlam | ProperName | RA | Declination | Distance | Mag | +--------------------+--------+------------+---------------+------------------+-------------------+----------+-------+ | Aaamazzarra | 141795 | 37Eps Ser | | 15.84691422 | 4.4775798 | 21.5564 | 3.71 | | Acamar | 18622 | The1Eri | | 2.97103212 | -40.30473491 | 49.456 | 2.88 | | Adelphous | 26967 | Alp Hor | | 4.23335592 | -42.29387294 | 35.9066 | 3.85 | | Akaali | 7969 | | | 1.31226233 | -26.50239036 | 61.1247 | 8.32 | | Algeron | 102124 | 2Xi Vir | | 11.75472355 | 8.25817475 | 36.6435 | 4.84 | | Alpha | 7439 | 37 Cet | | 1.23999082 | -7.9235004 | 24.3843 | 5.14 | | Alpha 441 | 127821 | | | 14.512861 | 63.18576376 | 31.736 | 6.1 | | Alrakis | 154905 | 21Mu Dra | | 17.08893952 | 54.46986308 | 26.9687 | 4.91 | | Alrescha | 12446 | 113Alp Psc | | 2.03411128 | 2.76376048 | 42.6439 | 3.82 | | Alzirr | 48737 | 31Xi Gem | | 6.75484265 | 12.89605513 | 17.5377 | 3.35 | | Andorgha | 137387 | Kap1Aps | | 15.52522795 | -73.38954647 | 312.5 | 5.4 | | Andoria | 61421 | 10Alp CMi | Procyon | 7.65514946 | 5.22750767 | 3.49736 | 0.4 | | Angel | 209952 | Alp Gru | Alnair | 22.13718789 | -46.96061593 | 31.0945 | 1.73 | | Ardana | 85503 | 24Mu Leo | | 9.87943268 | 26.00708498 | 40.783 | 3.88 | | Argelius | 99028 | 78Iot Leo | | 11.39871355 | 10.52969772 | 24.2365 | 4 | | Atbar | 222107 | 16Lam And | | 23.62602991 | 46.45917621 | 25.8131 | 3.81 | | Avenal | 358 | 21Alp And | Alpheratz | 0.13976888 | 29.09082805 | 29.7619 | 2.07 | | Axanar | 22049 | 18Eps Eri | | 3.549006 | -9.45830584 | 3.21802 | 3.72 | | Azha | 18322 | 3Eta Eri | | 2.94044549 | -8.89760976 | 40.833 | 3.89 | | Babel | 0 | | | 12.5564396662374 | 9.01747652538888 | 4.30663 | 13.04 | | Bajor | 111513 | | | 12.81383451 | 61.37814013 | 37.9939 | 7.36 | | Balosnee | 187691 | 54Omi Aql | | 19.85041673 | 10.4160539 | 19.3911 | 5.12 | | Barolia | 39425 | Bet Col | | 5.84932022 | -35.76929225 | 26.3574 | 3.12 | | Beloti | 29329 | | | 4.76677395 | 76.61137327 | 32.2269 | 6.46 | | Benecia | 18702 | | | 3.00991331 | 5.98644696 | 32.3939 | 8.11 | | Benzar | 190248 | Del Pav | | 20.14496114 | -66.17932101 | 6.10762 | 3.55 | | Beta Lankal | 71196 | | | 8.42195081 | -21.04610608 | 33.9443 | 6.01 | | Beta Rigel | 18978 | 11Tau3Eri | | 3.03988697 | -23.62433613 | 26.4201 | 4.08 | | Beta Thoridor | 30670 | | | 4.79737669 | -40.44589703 | 37.9507 | 9.28 | | Betazed | 90508 | | | 10.46772525 | 48.78704437 | 23.5571 | 6.42 | | Bolarus | 224022 | | | 23.91065012 | -40.30013654 | 27.8862 | 6.03 | | Brestant | 39364 | 15Del Lep | | 5.85532022 | -20.87751376 | 34.4234 | 3.76 | | Cardassia | 113337 | | | 13.02976446 | 63.61016308 | 37.4251 | 6.01 | | Carraya | 45289 | | | 6.40678097 | -42.84940778 | 27.894 | 6.67 | | Celes | 81997 | 31Tau1Hya | | 9.48578854 | -2.76895627 | 17.0999 | 4.59 | | Cestus | 20924 | | | 3.36633115 | -15.45871479 | 107.643 | 7.26 | | Ceti Alpha | 18884 | 92Alp Cet | Menkar | 3.03799418 | 4.08992539 | 67.4764 | 2.54 | | Cheron | 220729 | Omi Gru | | 23.44348452 | -52.721919 | 31.9693 | 5.53 | | Cheron - 83 Leo | 99491 | 83 Leo | | 11.44604048 | 3.01265989 | 17.671 | 6.49 | | Chin'toka | 78154 | 13Sig2UMa | | 9.17320171 | 67.13423886 | 20.4625 | 4.8 | | Clarus | 168009 | | | 18.25903537 | 45.20959588 | 22.686 | 6.3 | | Cochrane | 53244 | 23Gam CMa | | 7.06263699 | -15.63325876 | 123.305 | 4.11 | | Coridan | 39587 | 54Chi1Ori | | 5.9064122 | 20.27641498 | 8.66326 | 4.39 | | Cruses | 217364 | Zet Gru | | 23.01468731 | -52.75410562 | 34.4947 | 4.11 | | Davlos | 25490 | 38Nu Tau | | 4.05260466 | 5.98930909 | 39.6197 | 3.91 | | Delavi | 211336 | 23Eps Cep | | 22.25046638 | 57.04346522 | 25.7334 | 4.18 | | Deneb Kaitos | 4128 | 16Bet Cet | Diphda | 0.7264523 | -17.9866841 | 29.3772 | 2.04 | | Deneva | 14802 | Kap For | | 2.37567248 | -23.81631542 | 21.9298 | 5.19 | | Denobula Triaxa | 133640 | 44 Boo | | 15.06324494 | 47.65401409 | 12.7567 | 4.83 | | Devron | 142 | | | 0.10518422 | -49.07509405 | 25.641 | 5.7 | | Donatu | 42618 | | | 6.2001253 | 6.78369045 | 23.116 | 6.85 | | Dopteria | 142091 | 11Kap CrB | | 15.85387148 | 35.65822638 | 31.1236 | 4.79 | | Draygo | 46588 | | | 6.77068598 | 79.56627808 | 17.8508 | 5.44 | | Draylax | 209100 | Eps Ind | | 22.05484433 | -56.77980602 | 3.62634 | 4.69 | | Draylon | 13974 | 8Del Tri | | 2.28400489 | 34.22482985 | 10.846 | 4.84 | | Dreon | 2238 | | | 0.43504105 | -13.07783308 | 94.518 | 8.74 | | Epsilon Canaris | 52089 | 21Eps CMa | Adhara | 6.9770963 | -28.97208931 | 132.1 | 1.5 | | Fahleena | 4188 | 17Phi1Cet | | 0.73650151 | -10.60927365 | 64.3501 | 4.77 | | Farius | 106591 | 69Del UMa | | 12.25706919 | 57.03259792 | 24.9688 | 3.32 | | Ferenginar | 215812 | | | 22.79730597 | -4.22827511 | 31.3087 | 6.67 | | Fesarius | 136176 | | | 15.30560933 | 26.84019551 | 38.3142 | 6.59 | | Free Haven | 2286 | | | 0.44358397 | -14.02979312 | 85.4701 | 8.58 | | Galador | 9826 | 50Ups And | | 1.61332694 | 41.40638491 | 13.468 | 4.1 | | Gavaria | 216385 | 49Sig Peg | | 22.87326847 | 9.83555733 | 26.8456 | 5.16 | | Gemulon | 123691 | | | 14.13237341 | 48.21084198 | 50.8906 | 6.8 | | Gideon | 39014 | Del Dor | | 5.74622751 | -65.7355408 | 44.484 | 4.34 | | Gienah | 197989 | 53Eps Cyg | | 20.77012006 | 33.96945334 | 22.0946 | 2.48 | | Gorath | 79469 | 22The Hya | | 9.23938701 | 2.31502422 | 39.4633 | 3.89 | | Goren | 56986 | 55Del Gem | | 7.33538592 | 21.98233941 | 18.0343 | 3.5 | | Heze | 118098 | 79Zet Vir | | 13.5782652 | -0.59593821 | 22.4467 | 3.38 | | Hyralan | 29875 | Alp Cae | | 4.67606197 | -41.86357034 | 20.1329 | 4.44 | | Inkaria | 180711 | 57Del Dra | | 19.20920972 | 67.66131695 | 30.7314 | 3.07 | | Jouret | 11277 | | | 1.83276146 | -35.5399732 | 75.9878 | 8.47 | | Kalandra | 0 | | | 12.19082184 | 53.41904898 | 31.5457 | 8.14 | | Kantare | 50692 | 37 Gem | | 6.92185853 | 25.37563643 | 17.2741 | 5.74 | | Kavaria | 117710 | | | 13.5210672 | 42.10608614 | 80.7754 | 6.07 | | Khitomer | 34642 | Omi Col | | 5.29139537 | -34.89438961 | 33.7496 | 4.81 | | Klach D'Kel Bracht | 91858 | | | 10.60482626 | -10.58332632 | 57.5705 | 6.58 | | Kobheeria | 213558 | 7Alp Lac | | 22.52149326 | 50.28244976 | 31.3873 | 3.76 | | Kobliad | 432 | 11Bet Cas | Caph | 0.15280269 | 59.15021814 | 16.6973 | 2.28 | | Kohlan | 202275 | 7Del Equ | | 21.24133058 | 10.00771855 | 18.4809 | 4.47 | | Kora | 131873 | 7Bet UMi | Kochab | 14.84510983 | 74.15547596 | 38.7747 | 2.07 | | Korvat | 51199 | 19Pi CMa | | 6.92705526 | -20.13659348 | 29.2312 | 4.66 | | Kotaki | 103287 | 64Gam UMa | Phad | 11.89715035 | 53.69473296 | 25.6476 | 2.41 | | Kressari | 8512 | 45The Cet | | 1.40040311 | -8.18275372 | 35.1124 | 3.6 | | Kronos | 69965 | | | 8.32086023 | -5.61961414 | 34.153 | 7.43 | | L-370 | 17134 | | | 2.73736351 | -25.49551901 | 42.0168 | 6.96 | | L-374 | 19632 | | | 3.14786112 | -24.88797952 | 30.175 | 7.29 | | Lamemda | 224617 | 28Ome Psc | | 23.98850066 | 6.86359373 | 32.4886 | 4.03 | | Lazon | 209790 | 17Xi Cep | | 22.06310052 | 64.62775425 | 31.1818 | 4.26 | | Lorillia | 38393 | 13Gam Lep | | 5.74110416 | -22.44748663 | 8.96941 | 3.59 | | Lyshan | 109388 | | | 12.56790206 | 42.38953308 | 100.2 | 8.98 | | Malcor | 17094 | 87Mu Cet | | 2.7489926 | 10.11421979 | 25.8331 | 4.27 | | Maluria | 18907 | Eps For | | 3.02706953 | -28.09048221 | 30.3582 | 5.88 | | Mariah | 224945 | | | 0.03405407 | -2.76616306 | 59.1017 | 6.93 | | Mathen | 8511 | 44 Cet | | 1.40067591 | -8.00725234 | 67.4309 | 6.21 | | Maxia | 221575 | | | 23.55658753 | -12.66467637 | 34.8554 | 8.81 | | Medusa | 100407 | Xi Hya | | 11.55007195 | -31.85752405 | 39.6354 | 3.54 | | Memory Alpha | 116316 | | | 13.37618226 | 26.1156572 | 52.521 | 7.64 | | Mempa | 23319 | | | 3.71392279 | -37.31334485 | 54.5256 | 4.59 | | Menkalinan | 40183 | 34Bet Aur | | 5.99215817 | 44.94743492 | 25.1762 | 1.9 | | Meridian | 96937 | | | 11.16121729 | 2.45615312 | 30.553 | 7.69 | | Moropa | 924 | | | 0.22522989 | -40.3583852 | 33.3333 | 9.05 | | Morska | 41842 | | | 6.10461825 | -27.90591232 | 31.8674 | 8.95 | | Narendra | 27209 | | | 4.26250793 | -45.96922234 | 48.852 | 8.92 | | Nausicaa | 23588 | | | 3.75664477 | -27.86282003 | 21.7628 | 8.21 | | Nequencia | 13753 | | | 2.21669115 | -40.00519109 | 84.8176 | 8.68 | | Neural | 68255 | 16Zet2Cnc | | 8.20353023 | 17.64813756 | 25.5689 | 4.67 | | New France | 13789 | | | 2.23710482 | -3.63467442 | 22.8676 | 8.55 | | Nimbus | 121325 | | | 13.91619574 | -8.05876407 | 33.8181 | 6.19 | | No'Mat | 83808 | 14Omi Leo | | 9.68586607 | 9.89239902 | 41.4594 | 3.52 | | Nusakan | 137909 | 3Bet CrB | | 15.46384775 | 29.10549164 | 34.965 | 3.66 | | Organia | 18719 | | | 3.00471266 | -9.03970372 | 42.6803 | 8.94 | | Orion | 30652 | 1Pi 3Ori | | 4.83059395 | 6.96124744 | 8.02568 | 3.19 | | Orna | 147787 | Iot TrA | | 16.46590946 | -64.05800515 | 40.404 | 5.28 | | ORyans Planet | 78209 | 15 UMa | | 9.1478849 | 51.60472728 | 29.3083 | 4.46 | | Outpost Epsilon 1 | 18454 | 4 Eri | | 2.95658368 | -23.8620767 | 48.6855 | 5.44 | | Outpost Epsilon 10 | 101026 | | | 11.62918186 | 15.14292899 | 72.4113 | 8.85 | | Outpost Epsilon 3 | 35722 | | | 5.4329288 | -19.68986992 | 28.6533 | 7.53 | | Outpost Epsilon 7 | 96975 | | | 11.16775286 | 15.91296476 | 66.1376 | 7.51 | | Outpost Epsilon 8 | 16120 | | | 2.57402176 | -33.84732404 | 69.6379 | 8.59 | | P'Jem | 0 | | Luyten's Star | 7.45671236 | 5.23476432 | 3.79853 | 9.84 | | Penthara | 7673 | | | 1.27496226 | -4.862088 | 74.2942 | 8 | | Planet Q | 38114 | | | 5.74746274880591 | 32.39401221517 | 20.8333 | 8.15 | | Porrima | 110379 | 29Gam Vir | | 12.69444503 | -1.44952231 | 11.8301 | 2.74 | | Preenos | 58946 | 62Rho Gem | | 7.48516936 | 31.78407932 | 18.498 | 4.16 | | Pyrellia | 48682 | 56Psi5Aur | | 6.77898306 | 43.57702483 | 16.5126 | 5.24 | | Qualor | 57095 | | | 7.29154929 | -46.98066437 | 14.7732 | 6.7 | | Quinor | 222143 | | | 23.63282974 | 46.19946357 | 23.116 | 6.58 | | Rakon | 25680 | 39 Tau | | 4.08893042 | 22.00922152 | 16.7252 | 5.9 | | Regulon | 112429 | 8 Dra | | 12.92459864 | 65.43854743 | 28.8434 | 5.23 | | Risa | 16620 | 83Eps Cet | | 2.65936992 | -11.87158159 | 27.0343 | 4.83 | | Rog | 219592 | | | 23.28307372 | -7.16088877 | 37.9219 | 6.71 | | Romii | 0 | | | 14.18268874 | -31.29063408 | 17.188 | 10.77 | | Romulus | 117635 | | | 13.52789899 | -2.318046 | 30.9119 | 7.32 | | Rura Penthe | 50590 | | | 6.88319463 | -23.10788677 | 31.6356 | 8.99 | | Rymus | 127665 | 25Rho Boo | | 14.53051606 | 30.37114497 | 45.6204 | 3.57 | | Sarin | 156164 | 65Del Her | | 17.25053449 | 24.83958739 | 24.0674 | 3.12 | | Sherman's Planet | 247168 | | | 5.74910167 | 9.24379111 | 22.3864 | 11.35 | | Starbase 10 | 0 | | | 13.501762310911 | -8.70167256963546 | 14.8368 | 14.25 | | Starbase 11 | 233453 | | | 7.81102373 | 53.64985681 | 26.2674 | 8.86 | | Starbase 12 | 0 | | | 3.06744125429275 | -20.3696967629172 | 15.3846 | 12.84 | | Starbase 129 | 107824 | | | 12.38667871 | 42.72011949 | 88.7311 | 8.87 | | Starbase 157 | 99404 | | | 11.44034049 | 10.42292927 | 52.7983 | 8.65 | | Starbase 2 | 14044 | | | 2.27103018 | -9.82115255 | 46.4468 | 6.91 | | Starbase 214 | 8358 | | | 1.38065598 | 0.71263569 | 65.7462 | 8.26 | | Starbase 23 | 18709 | | | 2.98306338 | -43.7479235 | 38.9408 | 7.39 | | Starbase 24 | 48938 | | | 6.74776556 | -27.34238072 | 26.5957 | 6.43 | | Starbase 375 | 108574 | | | 12.46794287 | 44.79432132 | 39.2003 | 7.5 | | Starbase 47 | 25893 | | | 4.12617353 | 38.07508767 | 20.5804 | 7.13 | | Syrma | 124850 | 99Iot Vir | | 14.26691247 | -5.99952622 | 21.395 | 4.07 | | Talos | 17332 | | | 2.79093016 | 19.37221052 | 32.6158 | 6.9 | | Tammeron | 96833 | 52Psi UMa | | 11.16107206 | 44.49855337 | 45.0248 | 3 | | Tania Borealis | 89021 | 33Lam UMa | | 10.2849797 | 42.91446855 | 41.2031 | 3.45 | | Tarlac | 42807 | | | 6.22012679 | 10.62786588 | 18.1159 | 6.43 | | Taugus | 201601 | 5Gam Equ | | 21.17235307 | 10.13194861 | 35.2361 | 4.7 | | Tellar | 201091 | 61 Cyg | | 21.11412083 | 38.74149446 | 3.48274 | 5.2 | | Tellun | 82443 | | | 9.54551549 | 26.98912885 | 17.7462 | 7.05 | | Teneebia | 114378 | 42Alp Com | | 13.1665415 | 17.52911621 | 14.3246 | 4.32 | | Terra Nova | 4614 | 24Eta Cas | | 0.8180835 | 57.8165477 | 5.95274 | 3.46 | | Tiburon | 16046 | Ome For | | 2.56408677 | -28.2323401 | 139.082 | 4.96 | | Tohvun | 79028 | 16 UMa | | 9.23904198 | 61.42339501 | 19.5618 | 5.18 | | Torman | 8538 | 37Del Cas | | 1.43016751 | 60.23540347 | 30.4785 | 2.66 | | Tranome Sar | 18198 | | | 2.89751723 | -44.60579733 | 67.3854 | 7.7 | | Tribble Prime | 58207 | 60Iot Gem | | 7.42879891 | 27.79828561 | 38.61 | 3.78 | | Trill | 111456 | | | 12.81092684 | 60.31989667 | 24.1604 | 5.83 | | Vaalel | 14055 | 9Gam Tri | | 2.28856547 | 33.84732099 | 36.062 | 4.03 | | Valeria | 223346 | | | 23.81371126 | 2.21449865 | 55.2792 | 6.47 | | Valo | 108845 | 7 CVn | | 12.50086214 | 51.53556985 | 45.1467 | 6.21 | | Veridian | 80170 | | | 9.28252741 | -39.40145479 | 108.932 | 5.31 | | Volnar | 124330 | | | 14.18816102 | 54.40922813 | 57.6037 | 7.88 | | Vulcan | 26965 | 40Omi2Eri | | 4.25489948 | -7.64455846 | 5.04439 | 4.43 | | Wolf 359 | 0 | | Wolf 359 | 10.9450232999306 | 7.0530540844685 | 2.39063 | 13.45 | | Xarantine | 38678 | 14Zet Lep | | 5.78259715 | -14.82194717 | 21.5193 | 3.55 | | Xepolite | 90089 | | | 10.51806127 | 82.55853791 | 21.4869 | 5.25 | | Xyrillia | 5524 | | | 0.9469679 | -25.36336916 | 135.501 | 7.19 | | Yridia | 18692 | Zet For | | 2.99335152 | -25.27433851 | 32.3415 | 5.69 | | Zaran | 207958 | 51Mu Cap | | 21.88821772 | -13.55180134 | 27.6625 | 5.08 | | Zavijava | 102870 | 5Bet Vir | | 11.8448017 | 1.76537705 | 10.9004 | 3.59 | | Zibal | 20320 | 13Zet Eri | | 3.26389633 | -8.8198405 | 36.7918 | 4.8 | +--------------------+--------+------------+---------------+------------------+-------------------+----------+-------+ 180 rows in set (0.01 sec)