Announcement

Collapse
No announcement yet.

Select Query Compare Two Tables

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Select Query Compare Two Tables

    I'm looking for a select query that searches in both Table A and Table B, returns data where email is in Table B but not Table A and shows results firstname, surname, email, status.
    Many thanks

    Table A - firstname, surname, email, status

    Table B - firstname, surname, email, status


  • #2
    Please try to use LEFT JOIN or RIGHT JOIN. For more information, you can refer to your server's SQL manual.

    Comment

    Working...
    X