Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY instrumentchord.CT_ID' at line 1SELECT DISTINCT root.ROOT_ID, root.ROOT_NAME, chordtype.CT_ASCII, chordtype.CT_ASCII_ALT, instrumentchord.CT_ID, instrumentchord.IC_CHARTFILE FROM root INNER JOIN instrumentchord ON root.ROOT_NAME LIKE instrumentchord.ROOT_NAME INNER JOIN chordtype ON instrumentchord.CT_ID LIKE chordtype.CT_ID WHERE root.ROOT_ID = ORDER BY instrumentchord.CT_ID Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY instrumentchord.CT_ID' at line 1SELECT DISTINCT root.ROOT_ID, root.ROOT_NAME, chordtype.CT_ASCII, chordtype.CT_ASCII_ALT, instrumentchord.CT_ID, instrumentchord.IC_CHARTFILE FROM root INNER JOIN instrumentchord ON root.ROOT_NAME LIKE instrumentchord.ROOT_NAME INNER JOIN chordtype ON instrumentchord.CT_ID LIKE chordtype.CT_ID WHERE root.ROOT_ID = ORDER BY instrumentchord.CT_ID Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND instrumentchord.CT_ID = 0' at line 1SELECT DISTINCT keysig.KEY_ID, keysig.KEY_MAJABBREV, root.ROOT_ID, root.ROOT_NAME, chordtype.*, instrumentchord.* FROM root INNER JOIN instrumentchord ON root.ROOT_NAME LIKE instrumentchord.ROOT_NAME INNER JOIN chordtype ON instrumentchord.CT_ID LIKE chordtype.CT_ID INNER JOIN keysig ON keysig.KEY_ID LIKE instrumentchord.KEY_ID WHERE root.ROOT_ID = AND instrumentchord.CT_ID = 0Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND instrumentchord.CT_ID = 0' at line 1SELECT DISTINCT instrumentchord.IC_MIDI1, instrumentchord.IC_MIDI2, instrumentchord.IC_MIDI3, instrumentchord.IC_MIDI4, instrumentchord.IC_MIDI5, instrumentchord.IC_MIDI6 FROM instrumentchord INNER JOIN root ON instrumentchord.ROOT_NAME LIKE root.ROOT_NAME WHERE root.ROOT_ID = AND instrumentchord.CT_ID = 0Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1SELECT DISTINCT chordtype.CT_ASCII, chordtype.CT_NAME, chordtype.CT_ID, root.ROOT_ID, instrumentchord.ROOT_NAME, instrumentchord.IC_NOTE1, instrumentchord.IC_NOTE2, instrumentchord.IC_NOTE3, instrumentchord.IC_NOTE4, instrumentchord.IC_NOTE5, instrumentchord.IC_NOTE6 FROM instrumentchord INNER JOIN chordtype ON instrumentchord.CT_ID = chordtype.CT_ID INNER JOIN keysig ON instrumentchord.KEY_ID = keysig.KEY_ID INNER JOIN root ON instrumentchord.ROOT_NAME LIKE root.ROOT_NAME WHERE Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND instrumentchord.CT_ID = 0 AND chordtype.CT_ONKEY LIKE 'Y' AND keysig.KEY_MAJ' at line 1SELECT keysig.KEY_ID, keysig.KEY_MINABBREV, keysig.KEY_MAJABBREV, root.ROOT_ID, instrumentchord.* FROM keysig INNER JOIN instrumentchord ON instrumentchord.KEY_ID LIKE keysig.KEY_ID INNER JOIN root ON root.ROOT_NAME LIKE instrumentchord.ROOT_NAME INNER JOIN chordtype ON chordtype.CT_ID LIKE instrumentchord.CT_ID WHERE (root.ROOT_ID = AND instrumentchord.CT_ID = 0 AND chordtype.CT_ONKEY LIKE 'Y' AND keysig.KEY_MAJABBREV NOT LIKE root.ROOT_NAME) OR (root.ROOT_ID = AND instrumentchord.CT_ID = 0 AND chordtype.CT_ONMAJ LIKE 'Y' AND keysig.KEY_MAJABBREV LIKE root.ROOT_NAME)
Menu

The chord contains the following notes and scale degrees based on the major scale.

      
      

Key Signatures

The notes of the guitar chord fall within the following key signatures.

This web site and all of its content, text, and images are
copyright © 2010 - 2019 Don Adams
All rights reserved