Displaying 1 result from an estimated 1 matches for "contact_id_a".
Did you mean:
contact_id_b
2011 Oct 19
4
Using SQL "IN" with RJDBC or RMySQL
...t;- dbConnect(drv, "jdbc:mysql://localhost/civicrm",
"userid","pass")
org_table=dbGetQuery(conn,"SELECT id,organization_name FROM
civicrm_contact WHERE contact_type=?","organization")
dbGetQuery(conn,"SELECT id from civicrm_relationship WHERE contact_id_a
IN ? AND contact_id_b IN ?",org_table$id,org_table$id)