Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT2010Demo Database

sns
Loyal Listener
Posts: 33
Country: United States

ACT2010Demo Database

Hi,

 

1-I am using ACT2010Demo Database  . I wan to know how many table in database. and also wan to know where is store relationship tab value . it values is store into out of contact table. Because I cound not find out it's fields into contact table.

 

2- How can read relationship tab fields there is show value ---------following  

 

Relationship From

Conatct

Company

E-mail

Tile

ID/Status

I want to read these fields . how can read it please tell to me. 

 

If relationship field is into tbl_contact_contact table then how can read fields from tbl_contact and tbl_contact_contact table  like

 

I want to read example-(I know this type quesry is not possible into act)

 

SELECT contact_id,company anme, mailid from tbl_contact,tbl_contact_contact where  tbl_contact.contactid = tbl_contact_contact.contactid  andrelationship from<>""

 

please soon reply how can do this and read record agaist of act database. 

 

 

 

Saket Dwivedi

 

SNS System Indore