database where statment

keith21

keith21

Member
I am trying to link my data to another table.
Is this correct:

WHERE {thistable}.`id`
IN ( SELECT enbi.ENID, enbi.KnownASName FROM enbi
inner join opsmanager on enbi.ID = opsmanager.ENID)
 

Attachments

  • Untitled2.png
    Untitled2.png
    23 KB · Views: 117
  • Untitled3.png
    Untitled3.png
    18.4 KB · Views: 119
You must log in or register to reply here.

Useful links

  • Create a Fabrik Account (Downloads)
  • Create a Forum Account
  • Fabrik Wiki
  • Fabrik 4 Changelog /Install /Upgrade
    • We are in need of some funding.
    More details.

    Thank you.

    Members online

    No members online now.
    Total: 164 (members: 0, guests: 164)
    Back
    Top