How to perform a join operation for following table?

Question

Here is the database structure:

database structure

How can I find these columns: userId, firstName, lastName, path, file, type, content, size?

I am trying this query now, but it's not working.

SELECT t.userId, t.firstName, t.lastName, p.postId, p.content, p.file, p.type, p.path FROM tbl_users t JOIN post p ON p.userId = t.userId where t.userId = 'er.sharmauttam@gmail.com5a51e9ed426f8';

Any error you are getting while running this query? As per query you have posted you forgot to add comma between ``t.lastName`` and ``p.postId`` and also between ``p.type`` and ``p.path`` make sure there is no syntax error in your SQL query — Devang Naghera, Jan 07 '18 at 14:12
You're missing some commas: `t.lastName p.postId` should be `t.lastName, p.postId` and `p.type p.path` should be `p.type, p.path`. Your query looks good just some typographical errors. — cdaiga, Jan 07 '18 at 14:14
@cdaiga answer updated . can you please write query for this solution? — uttam sharma, Jan 07 '18 at 14:26
you can take column name as a sample data ;) and now i want userId, firstName, lastName, path, file, type, content. @cdaiga — uttam sharma, Jan 07 '18 at 14:28

Marvin Collins · Accepted Answer · 2018-01-07T14:26:21.150

1

if there is a table called tbl_users and post and both of them have userId then this query should help you.and i hope $userId is a variable/parameter

    'SELECT t.userId, t.firstName, t.lastName, p.postId, 
p.content, p.file, p.type, p.path FROM tbl_users t 
INNER JOIN post p ON p.userId = t.userId where t.userId = ' . $userId;

edited Jan 07 '18 at 14:26

answered Jan 07 '18 at 14:13

Marvin Collins

379
6
14

Your're missing some commas in your query. See my comment in the question. – cdaiga Jan 07 '18 at 14:18
i am not missing anything?? @cdaiga – Marvin Collins Jan 07 '18 at 14:20
1

yes $userId is variable . but this query is not working . – uttam sharma Jan 07 '18 at 14:21
hahahaha funny i guess u the one who have down voted my answer but its correct i fail to understand why u do that @cdaiga – Marvin Collins Jan 07 '18 at 14:21
@uttamsharma do u want to inner join the two tables?? that query should work perfectly well – Marvin Collins Jan 07 '18 at 14:22
Yes @MarvinCollins, I down voted because your answer is not correct. See my comment in the question. – cdaiga Jan 07 '18 at 14:23
yes . @MarvinCollins i want to retrieve these given fields . i dont know much about joins . i have given the data structure in images please check it which type of join will suitable . thanks for your efforts . – uttam sharma Jan 07 '18 at 14:25
@cdaiga check answer again . i updated my answer . thanks for point out. – uttam sharma Jan 07 '18 at 14:26
1

There you go, I changed my mind :) . Happy new year @MarvinCollins – cdaiga Jan 07 '18 at 14:26
thanks for the insight @cdaiga i have updated the answer it is supposed to work now – Marvin Collins Jan 07 '18 at 14:28
hahaha nice one @cdaiga thanks happy new year – Marvin Collins Jan 07 '18 at 14:29
happy new year guys . best experience ever on stackexchange . – uttam sharma Jan 07 '18 at 14:32
now can you please solve my problem ? ;) – uttam sharma Jan 07 '18 at 14:37
it solved what else do u need?? – Marvin Collins Jan 07 '18 at 14:39
yes worked now . thank you very much bro – uttam sharma Jan 07 '18 at 14:43

How to perform a join operation for following table?

1 Answers1