> i have 3 tables: offers, rewards, and sources. sources has just a source
> name and source id. both the offers and rewards tables have a "source_id"
> field which relates to the sources table. i need to write a query that
> selects the source name and the count in each table with that source id. is
> this possible? i tried:
I hope I understand your problem.
If you want results in each table, you should make two selects,
one for each table, to get the result for each. If you have 3 in
table rewards and two in table offers, what do you expect to get
from a combined query?
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php