UNIONs

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author john ackers

    (@john-ackers)

    11 years, 6 months ago

    Do you mean a single query that includes a union? Does the SQL run at the SQL command prompt?

    Thread Starter coleburg

    (@coleburg)

    11 years, 6 months ago

    in mysql you can write something like

    select * from tableA
    UNION
    select * from tableB

    and this will return the results of both, but I get 406 error when using the plug in.

    thanks

    http://dev.mysql.com/doc/refman/5.0/en/union.html

    Plugin Author john ackers

    (@john-ackers)

    11 years, 6 months ago

    Thanks for clarification. I have just tried

    select * from wp_posts where id < 90 union select * from wp_posts where id > 92

    …which works fine. Your apache error 406 looks very specific; I would look on the apache log file. Does your SQL statement run at the SQL command prompt (outside wordpress) ? Can you give an SQL statement that fails that I can try? thanks

    Thread Starter coleburg

    (@coleburg)

    11 years, 6 months ago

    Hi John, thank you for your reply and sorry for the delay in responding.

    Is there a way I can contact you directly to show you the query as it would contain sensitive information.

    thank you

    Plugin Author john ackers

    (@john-ackers)

    11 years, 6 months ago

    My email address is in the header of DBView.class.php. It’s obfuscated to prevent spamming.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘UNIONs’ is closed to new replies.