Member Avatar for squigworm

Hi everyone I am wondering if someone can help me understand why the Sub-Query's SELECT statement ended up producing the column name 'Code' vs. the initial SELECT statment call 'local_name' in the below screenshot Thanks in advance!

Query_SUB_QUERY_question_.png

  • 2 Contributors
  • 1 Reply
  • 65 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by Dani
Member Avatar for Dani

I am not sure what tutorial web app you’re using, but based on the SQL you provided, it’s absolutely positively wrong that it’s showing a code column instead of local_name column.

Perhaps you didn’t hit the Run Code button and what it’s showing is leftover from the last query you wrote?

Good luck!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.