Jump to content
  • Create New...
  • 0

db sysser help



2 answers to this question

Recommended Posts

  • 0

That mean the field "name" exist on both tables, monarch and player.

Modify the query using a.name or b.name instead only name.


SELECT empire, pid, a.name, money, windate FROM monarch a, player b where a.pid=b.id


  • Love 1
Link to comment
  • 0

use sql monarch:


-- ----------------------------
-- Table structure for monarch
-- ----------------------------
CREATE TABLE `monarch` (
  `empire` int(10) unsigned NOT NULL DEFAULT '0',
  `pid` int(10) unsigned DEFAULT NULL,
  `windate` datetime DEFAULT NULL,
  `money` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`empire`)

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Read our Rules
  • Activity

    1. 0

      Fix CursorImage 'NoneType' object is not callable.

    2. 0

      [Land of Heroes] We are looking for Game / Game Economy Designers

    3. 177

      Render Target Remastered

    4. 1

      MySQL stop when start server

    5. 0

    6. 59

      Emoji in TextLine

    7. 1

      MySQL stop when start server

  • Recently Browsing

    No registered users viewing this page.

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.