hi again,
I do have another problem, i do have a database with a peculiar structure. consider these:
table 1: calls
call_type call_ref client_name contact_name
Opportunity 1000 ABC Co. John Doe
Task 1000 DEF Co Jane
table 2: opportunity
opp_id description
1000 potential for 1000 bags order
table 3: task
task_id description
1000 deliver today before noon
Question: How do i make a select statement to show the following:
client_name contact_name call_type description
ABC Co John Doe opportunity potential for 1000 bags order
DEF Co Jane task deliver today before noon
Thanks in advance for all replies.
Cheers!