SQL query involving data from multiple tables

Question

I am really new to SQL & it would be really helpful if somebody can help with one simple query that I am struggling to write.

list ( plid, fid )

files ( fid, filename )

I want to get the fid & filename from the above tables where plid=3. The steps would be 1) Get the fid values from table "list" where plid=x 2) Get the filename from "files" for all the matched fid in table "list".

Could you please show what you've tried so far, and where it went wrong? It encourages others to help if you show your own efforts and where exactly you are stuck/which bits you don't understand. — Bridge
– Bridge, Commented Sep 22, 2014 at 10:54
Work through a good tutorial liek this one: sqlzoo.net/wiki/The_JOIN_operation — jpw
– jpw, Commented Sep 22, 2014 at 10:59
Thanks for the tutorial. I will definitely take a look at this today. Time was short & I needed an answer quick. — wrongElk
– wrongElk, Commented Sep 22, 2014 at 11:08

Ke Vin · Accepted Answer · 2014-09-22 10:54:35Z

1

That is exactly where you need a JOIN statement:

SELECT list.fid, files.filename FROM list INNER JOIN files ON files.fid = list.fid WHERE files.plid = 3

answered Sep 22, 2014 at 10:54

Ke Vin

2,0241 gold badge19 silver badges28 bronze badges

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

4 Comments

Ruslan Veselov Over a year ago

Yeah, it is very useful for his understandings.

Ke Vin Over a year ago

Write a better answer. Seriously, joins are so fundamental, a very quick search on google or clicking on one of the related questions on the side will tell him all he needs to know. I just lead him in the right direction.

Ruslan Veselov Over a year ago

You didn't understand my sarcasm. I mean, he have to write query by himself, without your direct answer. And where is your lead him? :)

wrongElk Over a year ago

Thanks Ke Vin. It worked. Regarding the query that I had done so far, SELECT list.fid, files.filename FROM list INNER JOIN files ON plid=3 and I was unsure about how to put the list.fid=files.fid.

Collectives™ on Stack Overflow

SQL query involving data from multiple tables

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related