sql query to select data from multiple table

Question

I have 3 table. I want to select the data from them order by date. I'm saving the date in unixtimestamp in all table. I'm using the following query:

select
  c.up_date, c.user_id, c.id,
  f.id, f.up_date, f.friend1, f.friend2, f.status,
  s.postdate, s.status, s.id, s.display_name, s.userid, s.userid1
from 
  c.cover_pic,
  s.wp_userstatus,
  f.wp_friends
where
  s.userid=c.friend1
  and s.userid=c.user_id 
  and f.status=1
  and c.user_id=4
order by s.postdate

Tablel structure is: cover_pic table:

 id  user_id   coverpic                              color   up_date
 1   4         496b02165600889daf51c6b04b257ec0.jpg  63ACFF  1353069741

wp_friends table:

id  friend1  friend2  status  up_date
12  1    4    2       1353064093
11  4    1    1       1353064093

wp_userstatus table:

id  status   display_name  userid  userid1  postdate    
6   awesome  paramveer     4       4        1352414658
7   lets     paramveer     4       4        1352414932

It is showing the following error:

#1142 - SELECT command denied to user 'kdgadget'@'localhost' for table 'cover_pic'

I want to show the data in order by date.

it is showing the following error#1142 - SELECT command denied to user 'kdgadget'@'localhost' for table 'cover_pic' — user1734190
– user1734190, Commented Nov 16, 2012 at 13:20

Cravid · Accepted Answer · 2012-11-16 13:24:49Z

2

SELECT command denied to user 'kdgadget'@'localhost' for table 'cover_pic'

should be a clear message. User kdgadget may not execute a SELECT command on table cover_pic. So it's a database configuration issue, not a query one.

answered Nov 16, 2012 at 13:24

Cravid

6832 gold badges7 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

guybennet · Accepted Answer · 2012-11-16 13:19:41Z

0

(SELECT * from in_order where `id` = '$id')
UNION
(SELECT * from pre_order where `id` = '$id')

but each table must be same length, size.

answered Nov 16, 2012 at 13:19

guybennet

6831 gold badge9 silver badges25 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:22:01Z

0

Use this query which uses joins and alias of tables are organized:

select c.up_date,c.user_id,c.id,f.id,f.up_date,f.friend1,f.friend2,f.status,
s.postdate, s.status,s.id,s.display_name.s.userid,s.userid1 
from cover_pic as c JOIN wp_userstatus as s,
ON s.userid=c.friend1 and s.userid=c.user_id and c.user_id=4 
JOIN  wp_friends as f ON f.status=1
order by s.postdate

Your error is not from sql. User don't have permissions to execute select. See error solving posts:

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Nov 16, 2012 at 13:23

Somnath Muluk

58.3k39 gold badges225 silver badges230 bronze badges

Comments

Vaibs · Accepted Answer · 2020-09-17 16:22:48Z

0

One of the possible cause may be by using the incorrect database or schema name.

edited Sep 17, 2020 at 16:22

answered Aug 19, 2015 at 9:40

Vaibs

2,15424 silver badges32 bronze badges

Collectives™ on Stack Overflow

sql query to select data from multiple table

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related