Combine multiple sql / mysql queries in one query

by

Because you screwed syntax order…

Multi join works like this:

select u.user_name,u.user_emailid,u.user_mobno,     q.que1_name,q.qa1,q.que2_name,q.qa2,q.que3_name,q.qa3,q.que4_name,q.qa4,q.que5_name,q.qa5,q.    que6a_name,q.qa6a,q.que6b_name,q.qa6b,q.que7_name,q.qa7,

r1.ref_name,r1.ref_email,r1.ref_mobno,   q.que1_name,q.qa1,q.que2_name,q.qa2,q.que3_name,q.qa3,q.que4_name,q.qa4,q.que5_name,q.qa5,q.    que6a_name,q.qa6a,q.que6b_name,q.qa6b,q.que7_name,q.qa7,

r2.ref_name,r2.ref_email,r2.ref_mobno,  q.que1_name,q.qa1,q.que2_name,q.qa2,q.que3_name,q.qa3,q.que4_name,q.qa4,q.que5_name,q.qa5,q.    que6a_name,q.qa6a,q.que6b_name,q.qa6b,q.que7_name,q.qa7,

r3.ref_name,r3.ref_email,r3.ref_mobno, q.que1_name,q.qa1,q.que2_name,q.qa2,q.que3_name,q.qa3,q.que4_name,q.qa4,q.que5_name,q.qa5,q.    que6a_name,q.qa6a,q.que6b_name,q.qa6b,q.que7_name,q.qa7

from question q
LEFT JOIN user u USING(user_id)
LEFT JOIN reference_1 r1 USING(ref_id_1)
LEFT JOIN reference_2 r2 USING(ref_id_2)
LEFT JOIN reference_3 r3 USING(ref_id_3)
WHERE q.flag = 1

Where must be at the end…
Joins must be stated completely and cannot be mixed. Order in dependency works you can have sub and subsub and so on dependencies without a problem.

One thing you did pretty good: You set-up same name for foreign key in both JOIN tables.
In this case you can simply replace r1.t1 = r2.t2 stuff and just define the join table in function USING(t1). 🙂

More Related Contents:

  1. CakePHP find method with JOIN
  2. How to execute my SQL query in CodeIgniter
  3. MySQL Join Multiple Rows as Columns
  4. to delete 14 row by 1 click
  5. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  6. how to get client’s IP address in sql database [closed]
  7. Using PHP data in MySQL [closed]
  8. Checking the availability of rooms
  9. PHP Parse Error – Creating a PHP script to verify user and pass [duplicate]
  10. How to properly set up a PDO connection
  11. Commands out of sync; you can’t run this command now
  12. Best way to get result count before LIMIT was applied
  13. Get table column names in MySQL?
  14. How to resolve ambiguous column names when retrieving results?
  15. Loading .sql files from within PHP
  16. How to insert multiple rows from a single query using eloquent/fluent
  17. Best way to defend against mysql injection and cross site scripting
  18. Use bound parameter multiple times
  19. PHP: multiple SQL queries in one mysql_query statement
  20. SQLSTATE[42S22]: Column not found: 1054 Unknown column – Laravel
  21. Laravel Eloquent, group by month/year
  22. Why does this return Resource id #2? [duplicate]
  23. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  24. How to generate unique id in MySQL?
  25. I’m getting this error code: Invalid argument supplied for foreach() [duplicate]
  26. how do I get month from date in mysql
  27. php/mysql zip code proximity search
  28. Php & Sql Injection – UTF8 POC
  29. Updating column so that it contains the row position
  30. Aggregated query without GROUP BY

Leave a Comment