[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

MySQL: Get results from one table only

Posted on 2014-02-17
1
Medium Priority
?
264 Views
Last Modified: 2014-02-17
This returns every column twice!  
SELECT * FROM promos.elqBooks_new t1 LEFT JOIN promos.elqBooks t2 ON t1.isbn = t2.isbn WHERE t2.isbn IS NOT NULL LIMIT 1

Open in new window

I only want the results from the table `promos.elqBooks_new`
0
Comment
Question by:hankknight
1 Comment
 
LVL 45

Accepted Solution

by:
Chris Stanyon earned 2000 total points
ID: 39865220
You need to select from the specific table alias:

SELECT t1.* FROM promos.elqBooks_new t1 LEFT JOIN promos.elqBooks t2 ON t1.isbn = t2.isbn WHERE t2.isbn IS NOT NULL LIMIT 1

Open in new window

0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question