Output two columns mysql

Question

I got mySQL query like this:

SELECT * 
FROM products_description pd 
LEFT JOIN products zp 
   ON pd.products_id = zp.products_id 
LIMIT 0 , 1000

This simply joins two tables together, and outputs columns and rows based on the same product id. Now I need only to narrow the columns to two, column_a AND column_b

How do I go about it?

@EDIT When two tables are joined am unable to get primary key in order to edit the table. How do I go around it to have primary key (unique) and make the table editable when joined.

If you just want to return `column_a` and `column_b`, then don't use `select *` use `select column_a, column_b...` — Taryn, Feb 21 '14 at 17:33

score 0 · Answer 1 · answered Feb 21 '14 at 17:32

0

SELECT column_a, column_b
FROM products_description pd 
LEFT JOIN products zp 
   ON pd.products_id = zp.products_id 
LIMIT 0 , 1000

answered Feb 21 '14 at 17:32

vekah

980
3
13
31

score 0 · Answer 2 · answered Feb 21 '14 at 17:33

0

you need just to select those two columns

  SELECT column_a , column_b
  FROM products_description pd 
  LEFT JOIN products zp 
  ON pd.products_id = zp.products_id 
  LIMIT 0 , 1000

answered Feb 21 '14 at 17:33

echo_Me

37,078
5
58
78

score 0 · Accepted Answer · answered Feb 21 '14 at 17:35

0

Try this, SELECT pd.column_a, pd.column_b

SELECT pd.column_a, pd.column_b
FROM products_description pd 
LEFT JOIN products zp 
   ON pd.products_id = zp.products_id 
LIMIT 0 , 1000

answered Feb 21 '14 at 17:35

Krish R

22,583
7
50
59

This is the working output :) Thanks `SELECT products_name, products_weight FROM products_description pd LEFT JOIN products zp ON pd.products_id = zp.products_id LIMIT 0 , 1000` – pasujemito Feb 24 '14 at 11:01

Output two columns mysql

3 Answers3