Author Topic: civicrm_email table is not working (Read 650 times)

prachi.tamrakar · June 17, 2009, 02:23:31 am

Hi
When i am joining drupal users table with civicrm_email table it is not working

Sunil · June 17, 2009, 05:32:56 am

You need to use the database prefix:
e.g.
$query = "SELECT a.field1, b.field1 FROM database1.table1 as a, database2.table1 as b WHERE database1.table1.field2='' AND ..... ";

HTh

Kiran Jagtap · June 17, 2009, 06:33:17 am

hi prachi,

As sunil replied query would also trigger a case of having different db tables for civicrm and drupal.
but more interesting thing is why you require to join these table in single query ? what is your use case ?

Better would be take a time and have a look of civicrm schema and check how civicrm communicate w/ drupal ( basically w/ cms )

kiran

CiviCRM Community Forums (archive)

News:

Author Topic: civicrm_email table is not working (Read 650 times)

prachi.tamrakar

civicrm_email table is not working

Sunil

Re: civicrm_email table is not working

Kiran Jagtap

Re: civicrm_email table is not working