Skip to content

Instantly share code, notes, and snippets.

@sufian07

sufian07/inner_join_subqueries.php

Last active August 16, 2018 12:48
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sufian07/1dca8258de8b301fef62c6809882c785 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sufian07/1dca8258de8b301fef62c6809882c785 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
inner_join_subqueries.php
<?php
sprintf(
'SELECT * FROM (%s)',
implode(
' INNER JOIN ',
array_map(
function($s,$i){
return sprintf(
"(%s) as temp%d %s",
$s,
$i,
($i > 0)?" USING (workorder_id) ":''
);
},
$subqueries,
array_keys($subqueries)
)
)
);
@sufian07
Copy link
Author

sufian07 commented Aug 16, 2018

useful when you have an array of sub queries need to INNER JOIN

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment