Posted by Toby A Inkster on 05/30/07 10:52

Johnny BeGood wrote:

> Any guidance on how to generate a crosstab report, have searched everwhere,
> well almost, no joy.

Do you mean on how to join two tables together?

SELECT *
FROM people p
INNER JOIN companies c ON p.employer=c.company_id
WHERE c.country='de' AND p.forename='Hans';

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.12-12mdksmp, up 95 days, 18:35.]

Non-Intuitive Surnames
http://tobyinkster.co.uk/blog/2007/05/25/non-intuitive-surnames/

• Next in forum: Re: Changing pages: header('location') or PHP require()?
• Prev in forum: Re: I need a subdomain service like kickme.to
• Thread view: Re: Crosstab Report

[Reply to this message]