Page 1 of 2 12 LastLast
Results 1 to 20 of 32
  1. 11-09-2011, 05:09 PM #1
    Johanis
    Johanis is offline Senior Member
    Join Date
    Oct 2010
    Posts
    139
    Rep Power
    0

    Default SQL Display statement

    How do I display all data from table one and two? How would the statement look then?
    Reply With Quote Reply With Quote
  2. 11-09-2011, 05:27 PM #2
    Shoss's Avatar
    Shoss
    Shoss is offline Member
    Join Date
    Feb 2011
    Posts
    94
    Rep Power
    0

    Default Re: SQL Display statement

    That really depends on what you're trying to accomplish. I would suggest reading this page and the entire w3 sql tutorial.
    Reply With Quote Reply With Quote
  3. 11-09-2011, 05:44 PM #3
    Johanis
    Johanis is offline Senior Member
    Join Date
    Oct 2010
    Posts
    139
    Rep Power
    0

    Default Re: SQL Display statement

    Quote Originally Posted by Shoss View Post
    That really depends on what you're trying to accomplish. I would suggest reading this page and the entire w3 sql tutorial.
    My two tables are linked (has a realtionship) and I want to display all the information, thats is all the information in table1 and all the information in table2.
    Reply With Quote Reply With Quote
  4. 11-09-2011, 06:24 PM #4
    Shoss's Avatar
    Shoss
    Shoss is offline Member
    Join Date
    Feb 2011
    Posts
    94
    Rep Power
    0

    Default Re: SQL Display statement

    Ok, then that page that i linked you to should be exactly what you need - read about the different types of joins.
    Reply With Quote Reply With Quote
  5. 11-09-2011, 06:50 PM #5
    Johanis
    Johanis is offline Senior Member
    Join Date
    Oct 2010
    Posts
    139
    Rep Power
    0

    Default Re: SQL Display statement

    My code now looks like this:
    Java Code: 
    displayMthd("All players","SELECT Table1.Player, Table1.Opponent, Table1.Date, Table2.Motto, Table2.Dateofbirth, Table.Placeofbirth, Table2.Member, Table2.Rank, Table2.Gender FROM Table1 INNER JOIN Table2 ON Table1.Player = Table2.Player ORDER BY Table1.Player");
    But it is stil giving me errors:
    Java Code: 
    Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
	at Scorekeeper.menuItem8ActionPerformed(Scorekeeper.java:151)
	at Scorekeeper.access$000(Scorekeeper.java:10)
	at Scorekeeper$1.actionPerformed(Scorekeeper.java:203)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2015)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2338)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
	at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
	at java.awt.Component.processMouseEvent(Component.java:6434)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
	at java.awt.Component.processEvent(Component.java:6199)
	at java.awt.Container.processEvent(Container.java:2203)
	at java.awt.Component.dispatchEventImpl(Component.java:4790)
	at java.awt.Container.dispatchEventImpl(Container.java:2261)
	at java.awt.Component.dispatchEvent(Component.java:4616)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4803)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4463)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4393)
	at java.awt.Container.dispatchEventImpl(Container.java:2247)
	at java.awt.Window.dispatchEventImpl(Window.java:2674)
	at java.awt.Component.dispatchEvent(Component.java:4616)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:662)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956)
	at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113)
	at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3109)
	at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:337)
	at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:252)
	at SQL3.displayMthd(SQL3.java:51)
	at SQL3.<init>(SQL3.java:16)
	at Scorekeeper.menuItem8ActionPerformed(Scorekeeper.java:147)
	... 30 more
    Reply With Quote Reply With Quote
  6. 11-09-2011, 07:20 PM #6
    Shoss's Avatar
    Shoss
    Shoss is offline Member
    Join Date
    Feb 2011
    Posts
    94
    Rep Power
    0

    Default Re: SQL Display statement

    Looks good, there's just a small mistype in your sql -

    Java Code: 
    ...teofbirth, Table.Placeofbirth, Table2...
    should probably be

    Java Code: 
    ...teofbirth, Table2.Placeofbirth, Table2...
    Reply With Quote Reply With Quote
  7. 11-09-2011, 07:31 PM #7
    Johanis
    Johanis is offline Senior Member
    Join Date
    Oct 2010
    Posts
    139
    Rep Power
    0

    Default Re: SQL Display statement

    Oh thank you!!! I now het the following errors:
    Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: java.sql.SQLException: Column not found
    at Scorekeeper.menuItem8ActionPerformed(Scorekeeper.j ava:151)
    at Scorekeeper.access$000(Scorekeeper.java:10)
    at Scorekeeper$1.actionPerformed(Scorekeeper.java:203 )
    at javax.swing.AbstractButton.fireActionPerformed(Abs tractButton.java:2015)
    at javax.swing.AbstractButton$Handler.actionPerformed (AbstractButton.java:2338)
    at javax.swing.DefaultButtonModel.fireActionPerformed (DefaultButtonModel.java:402)
    at javax.swing.DefaultButtonModel.setPressed(DefaultB uttonModel.java:259)
    at javax.swing.AbstractButton.doClick(AbstractButton. java:376)
    at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Bas icMenuItemUI.java:833)
    at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mou seReleased(BasicMenuItemUI.java:877)
    at java.awt.AWTEventMulticaster.mouseReleased(AWTEven tMulticaster.java:289)
    at java.awt.Component.processMouseEvent(Component.jav a:6434)
    at javax.swing.JComponent.processMouseEvent(JComponen t.java:3321)
    at java.awt.Component.processEvent(Component.java:619 9)
    at java.awt.Container.processEvent(Container.java:220 3)
    at java.awt.Component.dispatchEventImpl(Component.jav a:4790)
    at java.awt.Container.dispatchEventImpl(Container.jav a:2261)
    at java.awt.Component.dispatchEvent(Component.java:46 16)
    at java.awt.LightweightDispatcher.retargetMouseEvent( Container.java:4803)
    at java.awt.LightweightDispatcher.processMouseEvent(C ontainer.java:4463)
    at java.awt.LightweightDispatcher.dispatchEvent(Conta iner.java:4393)
    at java.awt.Container.dispatchEventImpl(Container.jav a:2247)
    at java.awt.Window.dispatchEventImpl(Window.java:2674 )
    at java.awt.Component.dispatchEvent(Component.java:46 16)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java: 662)
    at java.awt.EventDispatchThread.pumpOneEventForFilter s(EventDispatchThread.java:211)
    at java.awt.EventDispatchThread.pumpEventsForFilter(E ventDispatchThread.java:128)
    at java.awt.EventDispatchThread.pumpEventsForHierarch y(EventDispatchThread.java:117)
    at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:113)
    at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:105)
    at java.awt.EventDispatchThread.run(EventDispatchThre ad.java:90)
    Caused by: java.sql.SQLException: Column not found
    at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(JdbcOdb cResultSet.java:1849)
    at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbc ResultSet.java:410)
    at SQL3.displayMthd(SQL3.java:62)
    at SQL3.<init>(SQL3.java:16)
    at Scorekeeper.menuItem8ActionPerformed(Scorekeeper.j ava:147)
    ... 30 more
    Reply With Quote Reply With Quote
  8. 11-09-2011, 07:38 PM #8
    Shoss's Avatar
    Shoss
    Shoss is offline Member
    Join Date
    Feb 2011
    Posts
    94
    Rep Power
    0

    Default Re: SQL Display statement

    The error is telling you it can't find a column you specified in your sql. Double check your spelling and that all of the columns you are trying to get in your select statement exist in the tables in which you are looking for them.
    Reply With Quote Reply With Quote
  9. 11-09-2011, 08:43 PM #9
    Johanis
    Johanis is offline Senior Member
    Join Date
    Oct 2010
    Posts
    139
    Rep Power
    0

    Default Re: SQL Display statement

    Quote Originally Posted by Shoss View Post
    The error is telling you it can't find a column you specified in your sql. Double check your spelling and that all of the columns you are trying to get in your select statement exist in the tables in which you are looking for them.
    I have checked and double checked and double checked, and there is no spelling error and all the tables i want does exist.
    Reply With Quote Reply With Quote
  10. 11-09-2011, 09:31 PM #10
    Shoss's Avatar
    Shoss
    Shoss is offline Member
    Join Date
    Feb 2011
    Posts
    94
    Rep Power
    0

    Default Re: SQL Display statement

    Can you post the sets of columns in both of your tables and the sql query you are using now? There isn't much else i can help you with until i see the structure of your tables.
    Reply With Quote Reply With Quote
  11. 11-10-2011, 05:52 AM #11
    Johanis
    Johanis is offline Senior Member
    Join Date
    Oct 2010
    Posts
    139
    Rep Power
    0

    Default Re: SQL Display statement

    here is Table1 :
    Player Opponent Date
    Ping Pong YYYYMMDD

    Table2 :
    Motto Dateofbirth Placeofbirth Member Rank Player Gender
    er YYYYMMDD er er er Ping Male

    Java Code: 
     public SQL3 ()throws SQLException
      {
         displayMthd("All players","SELECT Table1.Player, Table1.Opponent, Table1.Date, Table2.Motto, Table2.Dateofbirth, Table2.Placeofbirth, Table2.Member, Table2.Rank, Table1 INNER JOIN Table2 ON Table1.Player = Table2.Player ORDER BY Table1.Player");
      }
    Reply With Quote Reply With Quote
  12. 11-10-2011, 09:57 AM #12
    Mr777
    Mr777 is offline Devil
    Join Date
    Nov 2011
    Location
    Pakistan
    Posts
    12
    Rep Power
    0

    Default Re: SQL Display statement

    Isn't * work in java?
    Why don't you try SELECT * FROM table1, table2 where (joins here) ?
    Reply With Quote Reply With Quote
  13. 11-10-2011, 02:32 PM #13
    Johanis
    Johanis is offline Senior Member
    Join Date
    Oct 2010
    Posts
    139
    Rep Power
    0

    Default Re: SQL Display statement

    Quote Originally Posted by Mr777 View Post
    Isn't * work in java?
    Why don't you try SELECT * FROM table1, table2 where (joins here) ?
    Then it gives the following errors:
    Java Code: 
    Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation.
	at Scorekeeper.menuItem8ActionPerformed(Scorekeeper.java:151)
	at Scorekeeper.access$000(Scorekeeper.java:10)
	at Scorekeeper$1.actionPerformed(Scorekeeper.java:203)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2015)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2338)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
	at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
	at java.awt.Component.processMouseEvent(Component.java:6434)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
	at java.awt.Component.processEvent(Component.java:6199)
	at java.awt.Container.processEvent(Container.java:2203)
	at java.awt.Component.dispatchEventImpl(Component.java:4790)
	at java.awt.Container.dispatchEventImpl(Container.java:2261)
	at java.awt.Component.dispatchEvent(Component.java:4616)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4803)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4463)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4393)
	at java.awt.Container.dispatchEventImpl(Container.java:2247)
	at java.awt.Window.dispatchEventImpl(Window.java:2674)
	at java.awt.Component.dispatchEvent(Component.java:4616)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:662)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation.
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956)
	at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113)
	at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3109)
	at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:337)
	at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:252)
	at SQL3.displayMthd(SQL3.java:52)
	at SQL3.<init>(SQL3.java:17)
	at Scorekeeper.menuItem8ActionPerformed(Scorekeeper.java:147)
	... 30 more
    Reply With Quote Reply With Quote
  14. 11-10-2011, 02:38 PM #14
    Mr777
    Mr777 is offline Devil
    Join Date
    Nov 2011
    Location
    Pakistan
    Posts
    12
    Rep Power
    0

    Default Re: SQL Display statement

    The problem doesn't seem to be with the SQL query but the java files you have in your project directory. Trace the exception and find where it causes the problem.
    Like
    at Scorekeeper.menuItem8ActionPerformed(Scorekeeper.j ava:151)
    Reply With Quote Reply With Quote
  15. 11-10-2011, 02:40 PM #15
    Johanis
    Johanis is offline Senior Member
    Join Date
    Oct 2010
    Posts
    139
    Rep Power
    0

    Default Re: SQL Display statement

    Oh no sorry, i frogt the WHERE part in the statement...The errors look like this now...Please disregard the last post
    Java Code: 
    Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(INNER JOIN Table2 ON Table1.Player = Table2.Player)'.
	at Scorekeeper.menuItem8ActionPerformed(Scorekeeper.java:151)
	at Scorekeeper.access$000(Scorekeeper.java:10)
	at Scorekeeper$1.actionPerformed(Scorekeeper.java:203)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2015)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2338)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
	at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
	at java.awt.Component.processMouseEvent(Component.java:6434)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
	at java.awt.Component.processEvent(Component.java:6199)
	at java.awt.Container.processEvent(Container.java:2203)
	at java.awt.Component.dispatchEventImpl(Component.java:4790)
	at java.awt.Container.dispatchEventImpl(Container.java:2261)
	at java.awt.Component.dispatchEvent(Component.java:4616)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4803)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4463)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4393)
	at java.awt.Container.dispatchEventImpl(Container.java:2247)
	at java.awt.Window.dispatchEventImpl(Window.java:2674)
	at java.awt.Component.dispatchEvent(Component.java:4616)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:662)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(INNER JOIN Table2 ON Table1.Player = Table2.Player)'.
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956)
	at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113)
	at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3109)
	at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:337)
	at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:252)
	at SQL3.displayMthd(SQL3.java:52)
	at SQL3.<init>(SQL3.java:17)
	at Scorekeeper.menuItem8ActionPerformed(Scorekeeper.java:147)
	... 30 more
    Reply With Quote Reply With Quote
  16. 11-10-2011, 04:15 PM #16
    Shoss's Avatar
    Shoss
    Shoss is offline Member
    Join Date
    Feb 2011
    Posts
    94
    Rep Power
    0

    Default Re: SQL Display statement

    Look at what the error is telling you

    Java Code: 
    Syntax error (missing operator) in query expression '(INNER JOIN Table2 ON Table1.Player = Table2.Player)'
    So somewhere around that expression is where you should look to find whats wrong. Compare it with other examples and see what is different with your syntax. What does your query look like now?

    Isn't * work in java?
    Why don't you try SELECT * FROM table1, table2 where (joins here) ?
    * works, but really shouldn't be used for anything other than dev/bug testing. Table structures can change and that has the possibility of messing up your project completely.
    Reply With Quote Reply With Quote
  17. 11-10-2011, 04:35 PM #17
    Johanis
    Johanis is offline Senior Member
    Join Date
    Oct 2010
    Posts
    139
    Rep Power
    0

    Default Re: SQL Display statement

    Quote Originally Posted by Shoss View Post
    Look at what the error is telling you

    Java Code: 
    Syntax error (missing operator) in query expression '(INNER JOIN Table2 ON Table1.Player = Table2.Player)'
    So somewhere around that expression is where you should look to find whats wrong. Compare it with other examples and see what is different with your syntax. What does your query look like now?



    * works, but really shouldn't be used for anything other than dev/bug testing. Table structures can change and that has the possibility of messing up your project completely.
    I tried it your way and it gave me errors. Here is my query now:
    Java Code: 
    displayMthd("","SELECT * FROM table1,table2 where (INNER JOIN Table2 ON Table1.Player = Table2.Player)");
    And here is my errors:
    Java Code: 
    Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(INNER JOIN Table2 ON Table1.Player = Table2.Player)'.
	at Scorekeeper.menuItem8ActionPerformed(Scorekeeper.java:151)
	at Scorekeeper.access$000(Scorekeeper.java:10)
	at Scorekeeper$1.actionPerformed(Scorekeeper.java:215)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2015)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2338)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
	at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
	at java.awt.Component.processMouseEvent(Component.java:6434)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
	at java.awt.Component.processEvent(Component.java:6199)
	at java.awt.Container.processEvent(Container.java:2203)
	at java.awt.Component.dispatchEventImpl(Component.java:4790)
	at java.awt.Container.dispatchEventImpl(Container.java:2261)
	at java.awt.Component.dispatchEvent(Component.java:4616)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4803)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4463)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4393)
	at java.awt.Container.dispatchEventImpl(Container.java:2247)
	at java.awt.Window.dispatchEventImpl(Window.java:2674)
	at java.awt.Component.dispatchEvent(Component.java:4616)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:662)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(INNER JOIN Table2 ON Table1.Player = Table2.Player)'.
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956)
	at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113)
	at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3109)
	at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:337)
	at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:252)
	at SQL3.displayMthd(SQL3.java:54)
	at SQL3.<init>(SQL3.java:18)
	at Scorekeeper.menuItem8ActionPerformed(Scorekeeper.java:147)
	... 30 more
    So I guess it has something to do with my INNER JOIN, but I don't know what can be wrong because I copied and pasted it from my database. That leaves only one thing that could be the problem: My relationships in my table...or something to do with my table itself.
    Or could it be something else?
    How can I get my database to you so you can see it?
    Reply With Quote Reply With Quote
  18. 11-10-2011, 05:13 PM #18
    Johanis
    Johanis is offline Senior Member
    Join Date
    Oct 2010
    Posts
    139
    Rep Power
    0

    Default Re: SQL Display statement

    I have looked again and again...I really do not know what is wrong...
    Reply With Quote Reply With Quote
  19. 11-10-2011, 05:35 PM #19
    Shoss's Avatar
    Shoss
    Shoss is offline Member
    Join Date
    Feb 2011
    Posts
    94
    Rep Power
    0

    Default Re: SQL Display statement

    Like i said, look at an example and compare it with your statement.

    W3's example vs yours, what are the differences?
    Java Code: 
    SELECT column_name(s)
  FROM table_name1
  INNER JOIN table_name2 
    ON table_name1.column_name=table_name2.column_name

SELECT *
  FROM table1, table2 
  where 
  (INNER JOIN Table2 
    ON Table1.Player = Table2.Player)
    Reply With Quote Reply With Quote
  20. 11-10-2011, 05:40 PM #20
    Johanis
    Johanis is offline Senior Member
    Join Date
    Oct 2010
    Posts
    139
    Rep Power
    0

    Default Re: SQL Display statement

    The column names and the where?
    Reply With Quote Reply With Quote
Page 1 of 2 12 LastLast
« FileWriter/Method Calling Problem | A little java challenge I was presented with today... »

Similar Threads

  1. Display only certain contents of text file and edit display
    By blkshrk81 in forum New To Java
    Replies: 1
    Last Post: 12-01-2010, 06:35 PM
  2. Using the return statement to display a string
    By Hoverboy in forum New To Java
    Replies: 6
    Last Post: 11-17-2010, 09:22 AM
  3. What is the different between Text format display on web browser and display on midle
    By Basit781 in forum CLDC and MIDP
    Replies: 1
    Last Post: 05-31-2010, 08:46 AM
  4. How to display a list of items and on click display subitems?
    By mandyj in forum New To Java
    Replies: 8
    Last Post: 12-29-2008, 07:12 AM
  5. Switch statement to display the name of the month
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 01-04-2008, 09:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules