Ask a Question related to ASP Database, Design and Development.
-
Bob Barrows #1
Re: SQL Join question
You want a crosstab. In Access, use the crosstab wizard. If SQL Server, do a
Google Advanced Groups search in m.p.sqlserver.programming for "crosstab".
Zillions of solutions have been posted there.
Bob Barrows
Tom B wrote:> This is more of a SQL query question than an asp question.
>
> I've three tables...
> tbl Staff
> ID int IDENTITY
> FName varchar
> LName varchar
>
> tblOffices
> OfficeID int IDENTITY
> Title varchar
>
> tblStaffExtensions
> StaffID int
> OfficeID int
> PhoneExtension char(5)
>
> I'd like a query that returns
> FName LName OfficeTitle Extension OfficeTitle2
> Extension Joe Blow Main Office 1234
> Branch 4321
>
> There are only two offices right now...but you never know when there
> may be more.
> Is this possible? Or am I dreaming?
> Thanks
Bob Barrows Guest
-
INNER JOIN query question
I have 2 tables with the following columns (other data fields omitted for brevity): cases.caseid cases.uid profiles.uid profiles.locationid... -
question about SQL query and cfoutput with INNER JOIN
I have a query that pulls data from two related tables (an Article Table and a Photo table, linked by ArticleID) Lets say i have 3 photos that are... -
join question - maybe map
Hi folks, I've got a hash such as: %masters=('VSL01'=>{'type'=>'S','name'=>'Vehicle Ledger accounts'}, 'ALD01'=>{'type'=>'S','name'=>'ALD... -
MySQL Left Join Question
This may not be the best place to ask this question, but I'm running into a problem when I perform a left join sql statement in PHP. The sql... -
JOIN/UNION question
OK basically I want to combine columns from two queries into a single table. I have one method that works but it feels like there is a simpler way to...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
