codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Search two tables with joins – complex query

    18th September 2018

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
     
    SELECT workers.*,
                jobtype.jobtype AS jobtype            
        FROM workers
        INNER JOIN jobtype ON workers.jobtypeid = jobtype.id
        LEFT JOIN invited ON invited.workerid = workers.id AND invited.jobid=166
        WHERE workers.jobtypeid = 10 AND workers.working='no'
        AND `invited`.`id` IS NULL
        ORDER BY workers.rep
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN