• Skip to primary navigation
  • Skip to content
  • Skip to footer
Arshad Mehmood Arshad Mehmood Software Engineer • Tech Enthusiast
  • About
  • Today I Learned
  • Portfolio
  • Resources
  • Newsletter
  • Contact
    1. Home
    2. /
    3. Today i learned
    4. /
    5. Sql
    6. /
    7. Select all columns from the joined table and some from the other
    Arshad Mehmood

    Arshad Mehmood

    Software Engineer, DevOps Enthusiast, and Android Developer. M.Sc. Business Informatics from University of Mannheim. Building scalable solutions and sharing knowledge.

    • Mannheim, Germany
    • My Android Apps
    • LinkedIn
    • GitHub
    • Twitter
    • Instagram

    Select all columns from the joined table and some from the other

    less than 1 minute read

    Select all columns from the joined table and some from the other

    This would select all the columns from the myTable.

    SELECT myTable.*, otherTable.foo, otherTable.bar...
    

    Got it from here

    Share on

    X Facebook LinkedIn Bluesky

    Leave a comment

    • Follow:
    • Twitter
    • GitHub
    • Instagram
    • Feed
    © 2025 Arshad Mehmood. Powered by Jekyll & Minimal Mistakes.