Help with a Mysql Query menu

User Tag List

Results 1 to 2 of 2
  1. #1
    Lytle69's Avatar Member
    Reputation
    13
    Join Date
    Aug 2008
    Posts
    66
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help with a Mysql Query

    I've used this Query Before But now for some reason it send me and error.
    #1242 - Subquery returns more than 1 row

    Code:
    SELECT *
    FROM `creature_proto` Where `entry` = (SELECT `entry` FROM `creature_spawns` WHERE `creature_spawns`.`map` =533)
    Anyone have a Suggestion or replacement Query?
    I wanna Select all the Npc's from Naxx in the creature_proto Table.

    Help with a Mysql Query
  2. #2
    Vision1000's Avatar Member
    Reputation
    104
    Join Date
    Jun 2008
    Posts
    122
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try this.

    Code:
    SELECT * FROM `creature_proto` Where `entry` = ANY (SELECT `entry` FROM `creature_spawns` WHERE `creature_spawns`.`map` =533)

Similar Threads

  1. [SQL] Need help with npc_trainer sql query
    By bergis1337 in forum WoW EMU Questions & Requests
    Replies: 4
    Last Post: 03-08-2011, 05:33 PM
  2. Seeking Help with Navicat/Mysql
    By munkenfunk in forum WoW EMU Questions & Requests
    Replies: 4
    Last Post: 04-12-2009, 07:27 AM
  3. Need Help With two SQL Queries
    By BoP in forum Programming
    Replies: 3
    Last Post: 06-12-2008, 09:15 PM
  4. Help with MySQL, keeps saying I can't start a Windows Service
    By Redviper2321 in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 11-11-2007, 03:17 PM
All times are GMT -5. The time now is 07:20 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search