|
|
Posted by Johnny BeGood on 05/30/07 11:22
Hi Toby,
Thanks for your reply, some thing like the following, noy sure how this will
format
Engineer Day1 Day2 Day3
John esb n/w esb
Mary n/w esb abc
almost like a spreadsheet ;)
Cheers
"Toby A Inkster" <usenet200705@tobyinkster.co.uk> wrote in message
news:7k10j4-h76.ln1@ophelia.g5n.co.uk...
> 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/
Navigation:
[Reply to this message]
|