Home how to join SQL with 3 tables
Reply: 0

how to join SQL with 3 tables

user413
1#
user413 Published in April 20, 2018, 6:02 pm

I'm trying to study SQL.

I have a problem with JOIN

I want to display ref_id, pro_name, class_name but I couldn't.

I find EFFICIENT solution.

MY QUERY (DOESN'T WORK)

SELECT
  ref_id, pro_name, class_name
FROM
  RC, RP, PP, LP
WHERE
  RC.ref_id = RP.ref_id
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.307395 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO