sql - Syntax error for mysql while doing inner join -


  SELECT t1. Type PERFORMS_SURGERY as a PS Inner (selection CPT, type of surgery) as T1 ON T1 .CPT = PS.CPT WHERE PS.PUsername = "klove30"   < p> I get a syntax error as PR Inner from "PERFORMS_SURGERY" (choose search CPT, type of surgery) ". What is the syntax error?   

  select t1. By type, ...   

You should not have a comma after the last column in the selection list.

Change this to change:

  SELECT t1 ... to type ...    

Comments

Popular posts from this blog

How can I add a seperate action listener to all 14 of my buttons at once that can determine player turn?(java) -

Simple file compression in C -

php - Sorting an multidimension array using usort fails -