N
no
Hi All
I hope someone can help me out as I'm a bit stumped with this...
I have 3 tables to record information about clients and their associated
publications
publications { pub_name, pub_id}
clients {client_name, client_id}
press_cuttings {cutting_id, pub_id, client_id, pub_date, page_fraction,
notes}
I need to create a query that for each client will list
1. the total page_fraction per month (the easy bit!)
2. publication names in the database, even those that have not covered the
client
So the output would be something like this:
Client A Jan Feb etc
----------
Publication 1 .5 .6 etc
Publication 2 .2 .3 etc
Publication 3
Publication 4 .24 .5 etc
where Publication 3 has not had any coverage of Client A. Its important to
see which publications Client A hasn't been in as well as those he has been
in.
I hope this makes sense!
Mo
I hope someone can help me out as I'm a bit stumped with this...
I have 3 tables to record information about clients and their associated
publications
publications { pub_name, pub_id}
clients {client_name, client_id}
press_cuttings {cutting_id, pub_id, client_id, pub_date, page_fraction,
notes}
I need to create a query that for each client will list
1. the total page_fraction per month (the easy bit!)
2. publication names in the database, even those that have not covered the
client
So the output would be something like this:
Client A Jan Feb etc
----------
Publication 1 .5 .6 etc
Publication 2 .2 .3 etc
Publication 3
Publication 4 .24 .5 etc
where Publication 3 has not had any coverage of Client A. Its important to
see which publications Client A hasn't been in as well as those he has been
in.
I hope this makes sense!
Mo